title: rownum=5 returns no data but table has 10 rows
body: <p>I have  a table emp (ename,eid,did,sal,sex) where column did is foreign key with another table dept (did,dname).</p>
  
  <p>I want to get the  nth sal of the company along with person's details .
  I am executing following query(my table  has 10 rows) </p>
  
  <pre><code>    SELECT rownum,vi.* FROM
     (SELECT * FROM emp ORDER BY sal desc) vi
     WHERE ROWNUM &gt;5;
  </code></pre>
  
  <p>when I execute rownum>5 or rownum=5 get "no data"
  but if i execute rownum&lt;5 then i get 4 rows displayed.</p>
  
  <p>.I want the data when I do rownum=n</p>