FETCH Archives - anydragon

MSSQL Paging

          SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, *
          FROM [tb_Service] AS [t]
          WHERE 1=1
          ORDER BY [fd_nIdService] DESC
          OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY

1

2

3

4

5

SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, *

FROM [tb_Service] AS [t]

WHERE 1=1

ORDER BY [fd_nIdService] DESC

OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY