Thread: Fw: Query

From

"shreedhar"

Date:

31 March 2003, 13:45:27

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