Hi All,
table consists of following data
empname deptid salary
xx 1 10000
xx1 2 5000
xx2 1 20000
xx3 1 10000
xx4 3 50000
xx5 4 10000
Can any body give Query to retreive employ name from department with maximum employee who is getting maximum salary.
expected result :
empname: xx2
Thanks And Regards,
Sreedhar