title: How to select data top x data after y rows from SQL Server
body: <p>For example I have a table which contains 10'000 rows. I want to select top 100 rows after top 500th row. How can I do this most efficiently. </p>
  
  <p>Query needed for SQL Server 2008</p>
  
  <hr>
  
  <p>For example i have this query already but i wonder are there any more effective solution</p>
  
  <pre><code>SELECT TOP 100 xx
  FROM nn 
  WHERE cc NOT IN 
     (SELECT TOP 500 cc
        FROM nn ORDER BY cc ASC)
  </code></pre>