sql server cte样例

最新推荐文章于 2024-08-07 11:39:09 发布

碧山云游

最新推荐文章于 2024-08-07 11:39:09 发布

阅读量127

点赞数

分类专栏： SQL与数据库文章标签：数据库 sql mysql

本文链接：https://blog.csdn.net/qq_41617901/article/details/125870023

版权

SQL与数据库专栏收录该内容

39 篇文章 2 订阅

订阅专栏

sql server cte样例


 
 --由子级递归父项
with cte (BudgetChildCode,ParentCode,BudgetChildName)
as
(--下级父项
select BudgetChildCode,ParentCode,BudgetChildName from [BudgetYearRelease] 
where  FinancialYearCode='02386692-404c-4396-9968-e161c418134d' and BudgetChildCode ='1-1-1'  --子级id
union all
--递归结果集中的父项
select t.BudgetChildCode,t.ParentCode,t.BudgetChildName from [BudgetYearRelease] as t
inner join cte as c on t.BudgetChildCode = c.ParentCode and  FinancialYearCode='02386692-404c-4396-9968-e161c418134d'
)
select stuff((
select BudgetChildName + '/'
from cte order by BudgetChildCode asc for xml path('')),1,0,'') as path;