本文介绍了一种使用SQL递归查询语法来遍历和获取组织结构的方法。通过WITH语句定义递归查询，实现从指定起始节点开始，沿着父-子关系逐级向下查询所有子节点的过程。这种方法适用于需要展示多层次组织架构的应用场景。
with org(OrgID,OrgName,ParentID,[level])
as
(
select orgid,orgname,parentid,0 as [level] from SYSOrg
where orgname like ''%'+ @DW +'%''
union all
select a.OrgID,a.OrgName,a.ParentID,[level]=1 from SYSOrg as a
inner join org as b
as
(
select orgid,orgname,parentid,0 as [level] from SYSOrg
where orgname like ''%'+ @DW +'%''
union all
select a.OrgID,a.OrgName,a.ParentID,[level]=1 from SYSOrg as a
inner join org as b
on a.ParentID = b.OrgID)
select * from org
扫一扫
1862
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
