title: OFFSET FETCH CLAUSE supported in SQL Server 2008 R2?
body: <p>I know OFFSET FETCH CLAUSE introduced in SQL Server 2012. I have installed SQL Server 2012 and I created a database with the compatibility level (SQL Server 2008). </p>
  
  <p>Then I tried this query:</p>
  
  <pre><code>SELECT * 
  FROM sys.objects 
  ORDER BY name 
        OFFSET 10 ROWS
        FETCH NEXT 20 ROWS ONLY
  </code></pre>
  
  <p>The above query returns 20 rows. How does <code>OFFSET FETCH CLAUSE</code> work in SQL Server 2008 R2?   </p>
  
  <p>I have tried in SQLfiddle as well by choosing <code>SQL SERVER 2008</code> <a href="http://sqlfiddle.com/#!3/b3799/1" rel="nofollow">http://sqlfiddle.com/#!3/b3799/1</a> and it works there as well.  </p>
  
  <p>I browsed in internet about it but I didn't find any solution as of now. Is that behaving because of 2012 Instance? Is there a way to make 2012 instance database to execute only SQL Server 2008 queries?(through any other settings if any)</p>