Oracle树结构查询按层级排序
SQL代码:
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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;
效果图:
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;
效果图: