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