Differences

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

--- kurs:connect_by_prior [2012/10/04 14:57]
mh
+++ kurs:connect_by_prior [2014/09/10 21:22]
127.0.0.1 external edit
@@ Line 53: / Line 53: @@
 ) connect by prior rn = rn-1
 start with rn = 1
+</code>
+=== Ähnliches Resultat, plain SQL ===
+<code>
+select a.first_name,
+        a.last_name, a.salary,
+        max(b.salary), (max(b.salary)-a.salary)
+from employees a join employees b
+on a.salary > b.salary
+and  a.employee_id <> b.employee_id
+group by a.first_name, a.last_name, a.salary
+order by a.salary desc;
 </code>

dokuwiki