--查询树状结构某节点(44)的上级所有根节点
with cte_parent(UserId,UserName,ReferralUserId,Level)
as (
--起始条件
select UserId,UserName,ReferralUserId,0 as Level
from aspnet_Members
where UserId = 103
--列出子节点查询条件
union all --递归条件
select a.UserId,a.UserName,a.ReferralUserId,b.Level+1
from aspnet_Members a
inner join
cte_parent b --执行递归,这里就要理解下了
on a.UserId=b.ReferralUserId
)
select * from cte_parent;
SqlServer查找上级
最新推荐文章于 2023-12-14 14:53:28 发布