How to skip the first n rows in sql query

February 16, 2023 by Tarik

For SQL Server 2012 and above, use this:

SELECT *
FROM Sales.SalesOrderHeader 
ORDER BY OrderDate
OFFSET (@Skip) ROWS FETCH NEXT (@Take) ROWS ONLY

https://stackoverflow.com/a/19669165/1883345