Sintha Dwida Ayu
6301124044
DBD 12-01
Latihan Hierarchical Retrieval
————————————–
Untuk soal silahkan klik disini
1. select last_name from employees where last_name!=’Lorentz’ connect by prior manager_id=employee_id;
2. select e.last_name, e.salary, d.department_name from employees e join departments d on(e.department_id=d.department_id) start with e.last_name=’Mourgos’ connect by prior e.employee_id=e.manager_id;
3. select e.last_name,e.employee_id, e.manager_id, d.department_name from employees e join departments d on (e.department_id=d.department_id) where e.job_id != ‘IT_PROG’ start with e.manager_id is NULL connect by prior e.employee_id = e.manager_id and e.last_name != ‘De Haan’;
4. select e.last_name, e.employee_id, e.manager_id, d.department_name
from employees e join departments d on (e.department_id=d.department_Id)
where last_name != ‘Chen’
start with e.manager_id = (select manager_id from employees where last_name=’Chen’)
connect by prior e.employee_id=e.manager_id;
5. select e.last_name, e.employee_id, e.manager_id, d.department_name, j.job_title from employees e join departments d on(d.department_id=e.department_id)
join jobs j on (j.job_id=e.job_id)
where e.department_id = (select department_id from employees where last_name=’Zlotkey’)
start with e.manager_id = (select manager_id from employees where last_name=’Zlotkey’)
connect by prior e.employee_id=e.manager_id;
6. select e.last_name, e.employee_id, e.manager_id, d.department_name, j.job_title from employees e join departments d on(d.department_id=e.department_id)
join jobs j on (j.job_id=e.job_id)
where (d.department_id,j.job_id) = (select department_id, job_id from employees where last_name=’Vargas’)
start with e.manager_id = (select manager_id from employees where last_name=’Vargas’) connect by prior e.employee_id=e.manager_id;
Recent Comments