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
效果图:
暂无评论
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14
2024-06-14