CODE EXAMPLE FOR SQL

sql server pagination limit

SELECT * FROM dbo.users WHERE id > 8
ORDER BY Id 
OFFSET 0 ROWS
FETCH NEXT 5 ROWS ONLY;