title: Oracle Rownum SQL
body: <p>What are the differences (advantages and disadvantages) between these two coding techniques?</p>
  
  <pre><code>select * from (
      select rownum rnun, * from table where rownum &lt; x
  ) where rnum &gt; y
  
  
  select * from (
      select * from table
  ) where rownum &lt; x and x &gt; y
  </code></pre>