title: SQL max() function returns wrong value for row with maximum value
body: <p>THIS IS MY TABLE STRUCTURE:</p>
  
  <pre><code>Anees   1000.00
      Rick    1200.00
      John    1100.00
      Stephen 1300.00
      Maria   1400.00
  </code></pre>
  
  <p>I am trying to find the MAX(salary) and the persons name .</p>
  
  <p>this is the query I use</p>
  
  <p>Select MAX(salary),emp_name
  FROM emp1</p>
  
  <p>I get <code>1400.00 and Anees.</code></p>
  
  <p>While the 1400 is correct the Anees is wrong,it should be maria. What changes do I need to make</p>