title: select 100 records in range
body: <p>Lets say I have a student table and there are 1000 records in it. </p>
  
  <p>I would like to write such a query that should select only 100 records but I should be able to define the range. </p>
  
  <pre><code>Ex. 100 records showing from 501 to 600
  or 100 records showing from 101 to 200
  </code></pre>
  
  <p>P.S. Yes! There is a identity column but it consists of random numbers.</p>
  
  <p>Thank you for your help.</p>