Differences

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

--- kurs:corellated_subquery_vs_pseudotable [2012/12/18 10:24]
mh
+++ kurs:corellated_subquery_vs_pseudotable [2014/09/10 21:22] (current)
@@ Line 68: / Line 68: @@
 </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>

dokuwiki