title: Is there efficient SQL to query a portion of a large table
body: <p>The typical way of selecting data is:</p>
  
  <pre><code>select * from my_table
  </code></pre>
  
  <p>But what if the table contains 10 million records and you only want records 300,010 to 300,020</p>
  
  <p>Is there a way to create a SQL statement on Microsoft SQL that only gets 10 records at once?</p>
  
  <p>E.g. </p>
  
  <pre><code>select * from my_table from records 300,010 to 300,020
  </code></pre>
  
  <p>This would be way more efficient than retrieving 10 million records across the network, storing them in the IIS server and then counting to the records you want.</p>