本文详细介绍了如何使用SQL UNION ALL和递归函数（在这里使用了自连接）来构建一个复杂的查询，该查询从组织数据库中提取并展示组织结构的层级关系。通过这种技巧，读者可以轻松地获取到详细的组织架构信息，适用于企业级应用或项目管理场景。
with partents as
(
select * from b_sys_org_adm where ORG_CODE ='ADM_100010301013'
UNION ALL
(SELECT a.* from b_sys_org_adm as a inner join
partents as b on a.ORG_CODE=b.ORG_PCODE
)
)
SELECT ORG_CODE,ORG_NAME FROM partents ;
(
select * from b_sys_org_adm where ORG_CODE ='ADM_100010301013'
UNION ALL
(SELECT a.* from b_sys_org_adm as a inner join
partents as b on a.ORG_CODE=b.ORG_PCODE
)
)
SELECT ORG_CODE,ORG_NAME FROM partents ;
扫一扫
295
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
