Fw: Query

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