select *
from table_name
where 1 = 1 --没有条件可以不写where
connect by parent_id = prior child_id
start with parent_id = 1
select orgid,fatherorgid,orgname
from gias_org
start with fatherorgid= 1
connect by prior orgid= fatherorgid
--如果需要排序
order siblings by 要排序的字段
select * from gias_org where fatherorgid =1 and orgid=1;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024