分页的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

posted @ 2009-08-28 15:05  斑点海豚---寂静的港湾  阅读(160)  评论(0编辑  收藏  举报