22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @pageIndex INT,@pageSize INT
SET @pageIndex=1
SET @pageSize=3
SELECT * FROM (
SELECT ROW_NUMBER() OVER (ORDER BY t.[type]) AS rid,t.[type]
FROM (
SELECT sv.[type] FROM MASTER.dbo.spt_values AS sv GROUP BY sv.[type]
) AS t
) AS t WHERE rid BETWEEN (@pageIndex-1)*@pageSize AND @pageIndex*@pageSize