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.
First Method
ORDER BY column_list [ASC |DESC]
OFFSET offset_row_count rows FETCH {FIRST | NEXT} fetch_row_count rows onlySecond Method
SELECT TOP (expression) [PERCENT]
[WITH TIES]
FROM
table_name
ORDER BY
column_name;
PERCENT
The PERCENT keyword indicates that the query returns the first N percentage of rows, where N is the result of the expression.
WITH TIES
The WITH TIES allows you to return more rows with values that match the last row in the limited result set.
