ORACLE 二叉树查询

二叉树查询，去掉树枝及相应的叶子
select employee_id, last_name, job_id, manager_id
from employees
start with employee_id=101
connect by prior employee_id=manager_id and manager_id!=108
二叉树查询，只是去掉叶子
select employee_id, last_name, job_id, manager_id
from employees
where manager_id!=108
start with employee_id=101
connect by prior employee_id = manager_id

二叉树查询关键字：select / start with / connect by prior