kurs:zeit_zwischen_jobs
Differences
This shows you the differences between two versions of the page.
| — |
kurs:zeit_zwischen_jobs [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | <code> | ||
| + | with date_hierarchy as ( | ||
| + | select rownum rn, | ||
| + | employee_id, | ||
| + | start_date, | ||
| + | end_date | ||
| + | from (select | ||
| + | employee_id, | ||
| + | start_date, | ||
| + | end_date from job_history | ||
| + | order by employee_id, start_date) | ||
| + | ) | ||
| + | select d1.employee_id, | ||
| + | d1.start_date, | ||
| + | d1.end_date, | ||
| + | d2.start_date, | ||
| + | d2.end_date, | ||
| + | d1.end_date - d1.start_date aufenthalt, | ||
| + | d1.end_date - d2.start_date | ||
| + | from date_hierarchy d1 join date_hierarchy d2 | ||
| + | on (d1.employee_id = d2.employee_id and d1.rn = d2.rn - 1) | ||
| + | -- where d1.employee_id = 176 | ||
| + | |||
| + | </code> | ||
kurs/zeit_zwischen_jobs.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
