title: SQL Server select rows between two values
body: <p>Hopefully the title explains it enough, but I want to be able to select rows in an SQL Server table between two values</p>
  
  <p>example</p>
  
  <p><code>SELECT * FROM table WHERE rows between 20 and 60</code></p>
  
  <p>I have tried the ROW_NUMBER() and then use a WHERE clause....</p>
  
  <p>Thanks,</p>
  
  <p>Jason</p>