如下
sql 代码
- SELECT ond.parentid as id
- FROM orgnode ond where ond.flag = 1
- START WITH ond.id=1
- CONNECT BY PRIOR ond.id = ond.parentid
- group by ond.parentid
- having COUNT(*)=1