1. 层级查询是单表查询,所以没有笛卡尔积,所以对于大表来说效率相对乐观一点
2.层次查询的结果相对来说不是很直观
select level,empno,ename,mgr
from emp
connect by prior empno = mgr
start with mgr is null
order by level;
大概就这样
select level,empno,ename,mgr
from emp
connect by prior empno = mgr
start with mgr is null
order by level;
大概就这样