SQL Server 使用ROW_NUMBER()进行分页

代码示例：

WITH domain AS(SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) ids,* FROM dbo.DomainInfo)
SELECT * FROM domain WHERE ids BETWEEN 1 AND 20 ORDER BY CityID DESC
View Code

 

posted @ 2015-02-15 14:24  whatever_pds  阅读(125)  评论(0)  编辑  收藏  举报