OFFSET (Pagination)

DECLARE @Offset INT = @RowsToReturn * (@PageNumber - 1)

SELECT *
FROM SchameName.TableName AS tb
ORDER BY tb.col1 -- you must include the order to have an offset
OFFSET @Offset ROWS
FETCH NEXT @RowsToReturn ROWS ONLY