kurs:procedure_salary_diff_simple_record
Differences
This shows you the differences between two versions of the page.
|
kurs:procedure_salary_diff_simple_record [2010/05/18 11:15] 127.0.0.1 external edit |
kurs:procedure_salary_diff_simple_record [2011/11/10 14:56] mh |
||
|---|---|---|---|
| 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> | ||
kurs/procedure_salary_diff_simple_record.txt ยท Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
