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
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
