3,491
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
select IDORGANIZATION ,parentid,connect_by_root(parentid)
from t_org_inf
START WITH a.IDORGANIZATION = in(1,2,3,4,5)
CONNECT BY PRIOR a.IDORGANIZATION = a.parentid
select *
from t_org_inf
START WITH a.IDORGANIZATION = in(1,2,3,4,5)
CONNECT BY PRIOR a.IDORGANIZATION = a.parentid