 <pre><code>SELECT * FROM ( SELECT q.*, rownum rn FROM ( SELECT * FROM maps006 ORDER BY id ) q ) WHERE rn BETWEEN 50 AND 100 </code></pre> <p>Note the double nested view. <code>ROWNUM</code> is evaluated before <code>ORDER BY</code>, so it is required for correct numbering.</p> <p>If you omit <code>ORDER BY</code> clause, you won't get consistent order.</p>