SQL Server Select top 10-20 results?

Question

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

That is

SELECT TOP 10 * FROM Product    

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

How do I do that?

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