THIS IS MY TABLE STRUCTURE:
Anees 1000.00
Rick 1200.00
John 1100.00
Stephen 1300.00
Maria 1400.00
I am trying to find the MAX(salary) and the persons name .
this is the query I use
Select MAX(salary),emp_name FROM emp1
I get 1400.00 and Anees.
While the 1400 is correct the Anees is wrong,it should be maria. What changes do I need to make