title: SQL ROWNUM how to return rows between a specific range
body: <p>How can I return a specific range of <code>ROWNUM</code> values?</p>
  
  <p>I'm trying the following:</p>
  
  <pre><code>select * from maps006 where rownum &gt;49 and rownum &lt;101
  </code></pre>
  
  <p>This returns only rows matching the <code>&lt;</code> operator.</p>