How do I write LINQ's .Skip(1000).Take(100) in pure SQL?

Question

What is the SQL equivalent of the `.Skip()` method in LINQ? For example: I would like to select rows 1000-1100 from a specific database table. Is this possible with just SQL? Or do I need to select the entire table, then find the rows in memory? I'd ideally like to avoid this, if possible, since the table can be quite large.

Accepted Answer

SQL Server 2012 and above have added this syntax:

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

How do I write LINQ's .Skip(1000).Take(100) in pure SQL?

Solution

Problem

Related problems