sqlserver 递归查询

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

导读：select * from UserInfo ;--所有数据 with cte as ( select * from UserInfo where UId='2' union all select B.* from cte A,UserInfo B where B.UFatherUserId = A.UId and A.UFatherUserId B.UId ) select * from cte--uid为2的数据及子数据 ? ?

select * from UserInfo ;--所有数据
with cte
as
(

select * from UserInfo where UId='2'

union all

select B.*

from cte A,UserInfo B where B.UFatherUserId = A.UId and A.UFatherUserId <>B.UId
)

select * from cte--uid为2的数据及子数据

（编辑：李大同）

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