A Simplified example is this -
ORDER BY [column]
OFFSET [offset] ROWS
FETCH NEXT [rowcount] ROWS ONLY;
The new options are market in red above, and are -
- [offset] - Position to start retrieving rows from.
- [rowcount] - How many rows to retrieve
You've been able to achieve this in the past with a little ingenuity as the table below shows.
|OFFSET & FETCH||New T-SQL features in SQL Server 2012 – OFFSET and FETCH
OFFSET – FETCH in SQL Server 2012
|ROW_NUMBER()||T-SQL: Paging with ROW_NUMBER()|
|SET ROWCOUNT Trick||A More Efficient Method for Paging Through Large Result Sets|