declare @pagenum int = 4
declare @rowsinpage int = 4
select * from emp order by id
offset (@pagenum-1)*@rowsinpage rows
fetch next @rowsinpage rows only
Download
0 formats
No download links available.
SQL SERVER||How to write a query for Pagination? | NatokHD