offset with order by in sql

SQL Server OFFSET FETCH clauses are used to set the limit to number of rows returned by a query.