The OFFSET and FETCH clauses are the options of the ORDER BY clause. They allow you to limit the number of rows to be returned by a query.
The following illustrates the syntax of the OFFSET and FETCH clauses:
ORDER BY column [ASC | DESC]OFFSET offset_row_count {ROW | ROWS}FETCH {FIRST| NEXT} fetch_row_count {ROW | ROWS} ONLY
In this syntax:
Tutorial: http://www.sqlservertutorial.net/sql-server-basics/sql-server-offset-fetch/