SQL 2005的ROW_NUMBER()实现分页功能

最新推荐文章于 2024-08-23 09:09:30 发布

weixin_30872867

最新推荐文章于 2024-08-23 09:09:30 发布

阅读量52

点赞数

原文链接：http://www.cnblogs.com/Nina-piaoye/archive/2008/07/30/1256334.html

版权

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

转载于:https://www.cnblogs.com/Nina-piaoye/archive/2008/07/30/1256334.html