title: SQL- ORDER BY DESC is not fetching results correctly
body: <p>I'm trying to fetch the maximum value of the column but the SQL query doesn't respond exactly.</p>
  <p>This is my complete query</p>
  <pre><code>select batch_upload_id from 
   (select batch_upload_id from cor_branch_upload 
    order by BATCH_UPLOAD_ID desc) 
  where rownum = 1
  </code></pre>
  <p>It should return 10 but it returns 9
  <a href="https://i.stack.imgur.com/RBo39.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RBo39.png" alt="enter image description here" /></a></p>