SQL Server 使用ROW_NUMBER()进行分页时间:2023-03-09 03:29:58 代码示例: WITH domain AS(SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) ids,* FROM dbo.DomainInfo) SELECT * FROM domain WHERE ids BETWEEN AND ORDER BY CityID DESC