title: using of rownum function with ">" sign in oracle
body: <p>I want to select the number of rows which are greater than 3 by rownum function i_e "(rownum>3)"
  for example if there are 25 rows and I want to retrieve the last 22 rows by rownum function.
  but when I write the </p>
  
  <pre><code>select * from test_table where rownum&gt;3;
  </code></pre>
  
  <p>it retrieve no row.
  can any one help me to solve this problem.
  thanks in advance</p>