title: Oracle Select query help please
body: <pre><code>SELECT  id
        FROM    ( 
   SELECT  id
        FROM   table      
        WHERE   
        PROCS_DT is null
        ORDER BY prty desc, cret_dt ) where rownum &gt;0 and rownum &lt;=100 
  </code></pre>
  
  <p>The above query is giving me back 100 records as expected</p>
  
  <pre><code> SELECT  id
            FROM    ( 
       SELECT  id
            FROM   table      
            WHERE   
            PROCS_DT is null
            ORDER BY prty desc, cret_dt ) where rownum &gt;101 and rownum &lt;=200 
  </code></pre>
  
  <p>why is the above query returning me zero records?</p>
  
  <p>Can some one help me how i can keep on. I am dumb in oracle...</p>