分页SQL

分页SQL

5表示分页数,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

posted @ 2012-08-15 10:39  小李飞术  阅读(167)  评论(0编辑  收藏  举报