Home SQL Server Pagination byAlex R. •January 15, 2017 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 Facebook Twitter