title: SQL Select query that returns a range
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/187998/row-offset-in-ms-sql-server">Row Offset in MS SQL Server</a>  </p>
  </blockquote>
  
  
  
  <p>I want to select a range from x1 to x2. Just like you can select the top results:</p>
  
  <pre><code>SELECT TOP X * FROM TABLE
  
  SELECT TOP 5 * FROM tUsers
  </code></pre>
  
  <p>But I would like to select middle results. So if I want results 10-20 is there a way to query that?</p>
  
  <pre><code>SELECT 10-20 * FROM TABLE?
  </code></pre>