Tag Archives: sql server 2011 order by enhancement example

How to use OFFSET / FETCH option in SQL Server Order By Clause ?

What is OFFSET FETCH  options in SQL Server ? SQL Server Denali (2011) has enhanced the ORDER BY clause. Now with ORDER BY clause we can also specify the OFFSET and FETCH options. By using OFFSET and FETCH I can specify, I wanted to have 6 records in  result sets and those 6 records should [...]