代码示例:
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
代码示例:
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
转载于:https://www.cnblogs.com/whatever199006/p/4292873.html