统计部门的员工个数(员工个数=本部门人数+下级部门人数)
https://gangling.iteye.com/blog/657395
解决我的问题的是他文章下面的 (oracle10g sql语句)
select a.root as id, nvl(sum(b.num), 0) num
from (select id, fid, connect_by_root(id) root
from (select d.deptid as id, d.supdepid as fid from dept d start with d.supdepid is null
connect by prior d.deptid = d.supdepid)
connect by prior id = fid) a
left join (select deptid, count(t.deptid) num from emp t group by t.deptid) b on a.id = b.deptid
group by root
order by root;