Selecting the top N rows in a table is no problem in SQL Server, but how to select the 2N to 3N rows is not as clear. Using the following SQL statement, you can achieve this functionality (retrieve the 21-40th highest orders):
SELECT TOP 20 OrderID, SubtotalFROM Northwind.dbo.[Order Subtotals]WHERE NOT OrderID IN ( SELECT TOP 20 OrderID FROM Northwind.dbo.[Order Subtotals] ORDER BY Subtotal DESC)ORDER BY Subtotal DESC