SQL - OFFSET And FETCH

--OFFSET FETCH

ORDER BY column_list [ASC |DESC]

OFFSET offset_row_count {ROW | ROWS}

FETCH {FIRST | NEXT} fetch_row_count {ROW | ROWS} ONLY

Example 

SELECT

    product_name,

    list_price

FROM

    production.products

ORDER BY

    list_price,

    product_name

OFFSET 10 ROWS

FETCH NEXT 10 ROWS ONLY;

SELECT

    product_name,

    list_price

FROM

    production.products

ORDER BY

    list_price DESC,

    product_name

OFFSET 0 ROWS

FETCH FIRST 10 ROWS ONLY;