1、可行的sql語句:select top 每頁多少*第幾頁 * from A
where A.主鍵 not in (select top 每頁多少*(第幾頁-1) A.主鍵 from A )
2、with temp as ( select row_number() over(order by nUserId) as rownum,cUserName from TUser )
select * from temp where rownum between 10 and 20
go
3、select * from (select Row_Number() over(order by nUserId) as rowId,* from TUser) u where u.rowId between 10 and 20
聯(lián)系客服