This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
kurs:corellated_subquery_vs_pseudotable [2012/12/18 10:24] mh |
kurs:corellated_subquery_vs_pseudotable [2013/05/15 14:13] mh |
||
---|---|---|---|
Line 68: | Line 68: | ||
</code> | </code> | ||
+ | |||
+ | ==== den Angestellten mit der niedrigsten id und gleichem Nachnamen ==== | ||
+ | |||
+ | <code> | ||
+ | select employee_id, | ||
+ | last_name | ||
+ | from employees e | ||
+ | where employee_id = | ||
+ | (select min(employee_id) from employees where last_name = e.last_name) | ||
+ | order by employee_id; | ||
+ | </code> |