This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
kurs:corellated_subquery_vs_pseudotable [2012/09/25 17:22] 127.0.0.1 external edit |
kurs:corellated_subquery_vs_pseudotable [2012/12/18 10:24] mh |
||
---|---|---|---|
Line 56: | Line 56: | ||
order by mehr desc | order by mehr desc | ||
</code> | </code> | ||
+ | |||
+ | ==== Finde den Angestellten mit dem höchsten Gehalt pro Department ==== | ||
+ | |||
+ | <code> | ||
+ | SELECT first_name, last_name, salary, dep_outer.DEPARTMENT_NAME, dep_outer.department_id | ||
+ | FROM EMPLOYEES join DEPARTMENTS dep_outer | ||
+ | on (dep_outer.DEPARTMENT_ID = EMPLOYEES.DEPARTMENT_ID) | ||
+ | where | ||
+ | salary = (select max(salary) from employees where department_id = dep_outer.department_id) | ||
+ | order by dep_outer.department_id, salary | ||
+ | </code> | ||
+ |