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.