代码示例：
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
SQL Server 使用ROW_NUMBER()进行分页
原文：http://www.cnblogs.com/whatever199006/p/4292873.html
