보관함

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