Hi All,
Another way of fetching result
SELECT * FROM tempemp WHERE salary IN ( SELECT MAX(Salary) FROM tempemp WHERE deptid IN ( SELECT MAX( deptid) FROM tempemp GROUP BY deptid ));
Regards,
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
