This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
kurs:connect_by_prior [2014/09/10 21:22] 127.0.0.1 external edit |
kurs:connect_by_prior [2019/05/23 15:00] (current) admin |
||
---|---|---|---|
Line 66: | Line 66: | ||
group by a.first_name, a.last_name, a.salary | group by a.first_name, a.last_name, a.salary | ||
order by a.salary desc; | order by a.salary desc; | ||
+ | </code> | ||
+ | |||
+ | === Hierchie in einer Zeile === | ||
+ | <code> | ||
+ | select first_name || ' ' || last_name employee_name, | ||
+ | level, lpad('>', level * 3, '*') p, | ||
+ | sys_connect_by_path ( first_name || ' ' || last_name, '/') h | ||
+ | from employees e | ||
+ | connect by prior employee_id = manager_id | ||
+ | start with employee_id = (select employee_id from employees where manager_id is null) -- = 100 | ||
</code> | </code> |