Paging Function In Sql Server 2012
USE ReportServer
GO
SELECT  *
FROM    Catalog
ORDER BY name
OFFSET 2 ROWS
FETCH NEXT 3 ROWS ONLY

http://msdn.microsoft.com/en-us/library/gg699618.aspx

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License