kurs:corellated_subquery_vs_pseudotable
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision Next revision Both sides next revision | ||
|
kurs:corellated_subquery_vs_pseudotable [2010/10/28 15:22] mh created |
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> | ||
| + | |||
kurs/corellated_subquery_vs_pseudotable.txt · Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
