Example OFFSET FETCH in TSQL
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.