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.
! At first will sorting, next return 50 rows.
! For large count of rows it take much resources, prefere to use it on limited dataset.