第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
转载于:https://www.cnblogs.com/wjonjon/archive/2009/08/28/1555803.html