title: Difference when using ROWNUM
body: <p>I search for Oracle paging query on the net, and most of them told me to wrap the query twice:</p>
  
  <pre><code>SELECT * 
    FROM (SELECT t.*, ROWNUM rn 
            FROM tableName t 
           WHERE ROWNUM &lt; 200) 
   WHERE rn &gt; 100
  </code></pre>
  
  <p>Just wondering if I can type it as:</p>
  
  <pre><code>SELECT *, ROWNUM rn 
    FROM tableName t 
   WHERE ROWNUN BETWEEN 100 AND 200
  </code></pre>
  
  <p>It seems the second one works as well.  Is there any (performance) differences between these two query?</p>