title: How to skip/offset rows in Oracle database?
body: <p>I am writing a very simple query for an Oracle DB (version 9).</p>
  
  <p>Somehow I can get first 5 rows:</p>
  
  <p><code>select * from cities where rownum &lt;= 5</code></p>
  
  <p>But skipping 5 rows returns an empty result:</p>
  
  <p><code>select * from cities where rownum &gt;= 5</code></p>
  
  <p>Using:</p>
  
  <ul>
  <li>Oracle SQL Developer </li>
  <li>Oracle DB version 9</li>
  </ul>
  
  <p>Why is the second query returning an empty result?</p>