title: Oracle/SQL: Why does query "SELECT * FROM records WHERE rownum >= 5 AND rownum <= 10" - return zero rows
body: <p>Why does the following query return 'zero' records:</p>
  
  <pre>
  SELECT * FROM records WHERE rownum >= 5 AND rownum &lt;= 10
  
       OR
  
  SELECT * FROM records WHERE rownum >= 5 
  </pre>
  
  <p>Whereas the following query return proper records:</p>
  
  <pre>
  SELECT * FROM records WHERE rownum &lt;= 15
  </pre>
  
  <p>Regards,<br>
  - Ashish</p>