22,300
社区成员




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