OFFSET provides a starting row from which Server needs to start fetching rows. It is defaulted to 0.
FETCH provides the number of rows we want to fetch from the final query set.
OFFSET and FETCH can be used only with an order by clause.
OFFSET clause is mandatory with the FETCH clause
We cannot use TOP clause with OFFSET and FETCH
The OFFSET and FETCH row count must be an integer value and it does not support sub queries
Want More SQL Deep Dives