User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
kurs:corellated_subquery_vs_pseudotable [2012/12/18 10:24]
kurs:corellated_subquery_vs_pseudotable [2014/09/10 21:22] (current)
Line 68: Line 68:
 </​code>​ </​code>​
 +==== den Angestellten mit der niedrigsten id und gleichem Nachnamen ====
 +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;​
kurs/corellated_subquery_vs_pseudotable.txt ยท Last modified: 2014/09/10 21:22 (external edit)