We can query the items of a selected page.
DECLARE @pageIndex INT=1
DECLARE @pageSize INT=10
SELECT * FROM myTable
OFFSET (@pageIndex-1)*@pageSize ROWS
FETCH NEXT @pageSize ROWS ONLY
A reader, writer, photographer and music lover.
We can query the items of a selected page.
DECLARE @pageIndex INT=1
DECLARE @pageSize INT=10
SELECT * FROM myTable
OFFSET (@pageIndex-1)*@pageSize ROWS
FETCH NEXT @pageSize ROWS ONLY