sql代码:
select t.* from pt_org_info t start with t.id = 1 connect by t.par_id = prior t.id order siblings by t.id;
view code
效果图:
sql代码:
select t.* from pt_org_info t start with t.id = 1 connect by t.par_id = prior t.id order siblings by t.id;
view code
效果图: