sqlserver 递归查询

概述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

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的数据及子数据

 

 

总结

以上是内存溢出为你收集整理的sqlserver 递归查询全部内容，希望文章能够帮你解决sqlserver 递归查询所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。