title: Table rownum returns 0 records if rownum is tested for value greater than 100
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/9240192/rownum-not-working-with-query">Rownum not working with query</a>  </p>
  </blockquote>
  
  
  
  <p>I am running some tests for how <code>rownum</code> works. Please could someone explain the output of the following queries - Specifically why the third query is returning 0 rows. </p>
  
  <p>Query 1 - Returns 2456 rows</p>
  
  <pre><code>Select rownum, s.id, s.title, sv.version_id
  from software s JOIN software_version sv on (s.id = sv.id);
  </code></pre>
  
  <p>Query 2 - Returns 100 rows</p>
  
  <pre><code>Select rownum, s.id, s.title, sv.version_id
  from software s JOIN software_version sv on (s.id = sv.id)
  where rownum between 1 and 100;
  </code></pre>
  
  <p>Query 3 - Returns 0 rows</p>
  
  <pre><code>Select rownum, s.id, s.title, sv.version_id
  from software s JOIN software_version sv on (s.id = sv.id)
  where rownum between 101 and 400;
  </code></pre>
  
  <p>Thanks</p>