How to skip/offset rows in Oracle database?
<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>