How to Skip Rows in SQL: The Equivalent of LINQ's Skip() Method?

SQL Equivalent of LINQ's Skip() Method

In LINQ, the .Skip() method allows you to skip a specified number of rows from the beginning of a sequence. This can be useful for pagination or selecting a specific subset of data.

SQL Equivalent for .Skip()

In SQL Server 2012 and above, you can use the OFFSET ... ROWS FETCH NEXT ... ROWS ONLY syntax to achieve similar functionality:

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

Here, @Skip represents the number of rows to skip, and @Take represents the number of rows to fetch after skipping.

Usage Example

To select rows 1000-1100 from the Sales.SalesOrderHeader table, use the following query:

SELECT *
FROM Sales.SalesOrderHeader 
ORDER BY OrderDate
OFFSET 999 ROWS FETCH NEXT 100 ROWS ONLY

This query will return only the 100 rows from positions 1000-1100, without having to select the entire table into memory first.

The above is the detailed content of How to Skip Rows in SQL: The Equivalent of LINQ's Skip() Method?. For more information, please follow other related articles on the PHP Chinese website!