Fw: Query

Поиск

Список

Период

Сортировка

От	shreedhar
Тема	Fw: Query
Дата	31 марта 2003 г. 10:45:27
Msg-id	005e01c2f756$8e873930$1201a8c0@a4005 обсуждение исходный текст
Список	pgsql-general

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

В списке pgsql-general по дате отправления: