An "OFFSET FETCH" is a filter, that allows to miss some number of first rows.

For example:

select field1, field2, field3 
from table1
order by field1, field2
offset 100 rows fetch next 50 rows only;

That example return the rows from 101 to 150, from all rows that ordered by field1 and field2.