User Tools

Site Tools


kurs:connect_by_prior

This is an old revision of the document!


select level, lpad('-', level*2-2, '=') as position, 
       employee_id as emp_id, 
       last_name as emp_name, 
       prior employee_id as man_id, 
       prior last_name as man_name,
       salary - prior salary as diff
       from employees
--where salary - prior salary > 0
connect by prior employee_id = manager_id
start with employee_id = 100

ast abschneiden

select level, lpad('-', level*2-2, '=') as position, 
       employee_id as emp_id, 
       last_name as emp_name, 
       prior employee_id as man_id, 
       prior last_name as man_name,
       salary - prior salary as diff
       from employees
--where salary - prior salary > 0
-- where prior employee_id != 108
connect by prior employee_id = manager_id and employee_id != 108
start with employee_id = 101
select hd, count(hd) from (
  select extract(year from hire_date) hd  from employees
  --union
  --select level+1985 i from dual connect by level < 20
  )
group by hd 
order by hd


select jahr, count(hire_date) from 
(select level+1985 jahr from dual connect by level < 20) left join employees
on  extract(year from hire_date) = jahr
group by jahr
order by jahr
kurs/connect_by_prior.1348586541.txt.gz · Last modified: 2014/09/10 21:22 (external edit)