title: How can I get a row which has biggest value?
body: <p>I got query like this</p>
  
  <pre><code>SELECT 
    IMAGE_PATH, IMAGE_ID, DOC_NID 
  FROM
    TBL_IMAGE WHERE IMAGE_ORD = 1
  </code></pre>
  
  <p>And have follow conditions</p>
  
  <ul>
  <li>image_ord should br changed to image_ord=max value </li>
  <li>image_ord column is number type and it has some duplication</li>
  <li>I need only one row with biggest value of image_ord</li>
  <li>it could be handled deal with rownum, but I do not want to Since it has many layers above this.(It is subquery) </li>
  </ul>
  
  <p>Could it be handled without subquery?</p>