dokuwiki

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