SQL Server 选择前 10-20 个结果? [英] SQL Server Select top 10-20 results?

问题描述

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

I have two columns the first one I want top 10 products (1-10)

那就是

SELECT TOP 10 * FROM Product   

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

In the second column I want the next 10 results (11-20)

我该怎么做?

推荐答案

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

这篇关于SQL Server 选择前 10-20 个结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！