27,580
社区成员
发帖
与我相关
我的任务
分享
declare @pageindex int,@pagesize int
select * from
(
select *,rn=row_number() over(order by id)
from tb
)t
where rn between (@pageindex-1)*@pagesize+1 and @pageindex*@pagesize
DECLARE @pagenum AS INT, @pagesize AS INT
SET @pagenum = 2
SET @pagesize = 3
SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY newsid DESC) AS rownum,
newsid, topic, ntime, hits
FROM news) AS D
WHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize
ORDER BY newsid DESC