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