sqlserver 根据子节点查找所有父节点

发布时间：2020-12-12 12:46:06 所属栏目：MsSql教程来源：网络整理

导读：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 ;

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 ;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!