This shows you the differences between two versions of the page.
kurs:zeilen_vergleichen [2014/09/10 21:22] |
kurs:zeilen_vergleichen [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | select a.employee_id, a.first_name, a.last_name, a.salary, | ||
+ | b.employee_id, b.first_name, b.last_name, b.salary | ||
+ | -- , prior a.salary | ||
+ | from | ||
+ | (select employee_id, first_name, last_name, salary | ||
+ | from employees order by salary desc, employee_id) a, | ||
+ | ( | ||
+ | (select employee_id, first_name, last_name, salary | ||
+ | from employees) | ||
+ | minus | ||
+ | select * from | ||
+ | (select employee_id, first_name, last_name, salary | ||
+ | from employees order by salary desc) where rownum<2 | ||
+ | ) b | ||
+ | where b.employee_id(+) = a.employee_id | ||
+ | </code> |