select
count(*),
root
from
(
select dep.dep_id,dep.dep_parent,connect_by_root(dep.dep_id) root,connect_by_root(dep.name_mix) rootName from police_command_ds_dep dep
start with dep.dep_parent = '1'
connect by prior dep.dep_id = dep.dep_parent
) group by root
Select * From POLICE_COMMAND_DS_DEP
Start With dep_id = '1'
Connect By nocycle Prior dep_id = dep_parent
说明:nocycle 避免一条数据的 dep_id = 1 dep_parent=1导致死循环