SQL Server Pagination

SQL server
With MSSQL 2012 and above pagination has never been so easy:

SELECT * FROM Log ORDER BY id OFFSET 5 ROWS FETCH NEXT 10 ROWS ONLY


Post a Comment

Previous Post Next Post