OFFSET FETCH

Syntax:

SELECT <columns>
FROM <table>
ORDER BY <columns>
OFFSET <number_of_rows_to_skip> ROWS 
FETCH FIRST|NEXT <number_of_rows_to_return> ROWS ONLY;

Example:

SELECT TOP(20) * FROM Application.Cities c
ORDER BY c.CityID

SELECT * FROM Application.Cities c
ORDER BY c.CityID
OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY