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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24751738/viewspace-707159/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24751738/viewspace-707159/