query
how to use Pagenation in MSSQL
SELECT * from {table}
ORDER BY "{column}"
OFFSET page number start from zero} ROWS
FETCH NEXT {PAge Size} ROWS ONLY
SELECT * from {table}
ORDER BY "{column}"
OFFSET page number start from zero} ROWS
FETCH NEXT {PAge Size} ROWS ONLY