SqlServer递归查询

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

导读：最近整理字典，频繁用到递归查询，老是记不住，留个代码以后备用！ ?with cte as? (select Zdxmc,(select Zdxmc from GC_Sys_Zdx where Zdxid = a.Parentid) as 'Parent',a.Parentid from GC_Sys_Zdx a where Bz = '现从事专业' ?union all? select b.Zdxmc,

最近整理字典，频繁用到递归查询，老是记不住，留个代码以后备用！

?with cte as?

(select Zdxmc,(select Zdxmc from GC_Sys_Zdx where Zdxid = a.Parentid) as 'Parent',a.Parentid from GC_Sys_Zdx a where Bz = '现从事专业'
?union all?

select b.Zdxmc,(select Zdxmc from GC_Sys_Zdx where Zdxid = b.Parentid) as 'Parent',b.Parentid from ?cte,GC_Sys_Zdx b where cte.Parentid = b.Zdxid

)

?select * ?from cte?

（编辑：李大同）

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