1、可行的sql語(yǔ)句:select top 每頁(yè)多少*第幾頁(yè) * from A
where A.主鍵 not in (select top 每頁(yè)多少*(第幾頁(yè)-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)系客服