SQL Server 分页语句查询

--查询第10页的数据(15条)

SELECT TEMP1.* FROM(
SELECT TOP 15 ROW_NUMBER() OVER(ORDER BY ID ASC) AS ROWID,* FROM LeaveWordView) AS TEMP1
WHERE ROWID>10
原文地址:https://www.cnblogs.com/weimingxin/p/7008959.html