This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
kurs:procedure_salary_diff_simple_record [2010/05/18 11:15] 127.0.0.1 external edit |
kurs:procedure_salary_diff_simple_record [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 37: | Line 37: | ||
END; -- Procedure | END; -- Procedure | ||
+ | </code> | ||
+ | |||
+ | ====== Gehaltsunterschied mit reinem Oracle-SQL ====== | ||
+ | |||
+ | |||
+ | <code> | ||
+ | select last_name, salary, prior salary-salary from ( | ||
+ | select rownum rn , rownum-1 rnm, last_name, salary from ( | ||
+ | select last_name, salary from employees order by salary desc) | ||
+ | ) connect by prior rn = rnm | ||
</code> | </code> |