SQL Server 选择前 10-20 个结果？

Question

我有两列，第一列我想要前 10 名产品 (1-10)

那就是

SELECT TOP 10 * FROM Product   

在第二列中，我想要接下来的 10 个结果 (11-20)

我该怎么做？

Answer 1

WITH T AS
(
SELECT TOP 20 name, 
       row_number() OVER (ORDER BY id) AS RN
FROM Products
ORDER BY id
)
SELECT 
       MAX(CASE WHEN RN <=10 THEN name END) AS Col1,
       MAX(CASE WHEN RN > 10 THEN name END) AS Col2
FROM T       
GROUP BY RN % 10