分页的Select语句
第n页显示数据记录的语句应该是:
select top 5 * from UserInfo where UserID not in
(select top (n-1)*5 UserId from UserInfo order by UserID asc)
order by UserID asc
第n页显示数据记录的语句应该是:
select top 5 * from UserInfo where UserID not in
(select top (n-1)*5 UserId from UserInfo order by UserID asc)
order by UserID asc