sql递归查询部门数据

1  with cte as 
2  ( 
3  select a.DepartCode,a.DepartName,a.ParentDepartCode from tbDeparts a where ParentDepartCode='2' 
4  union all  
5  select k.DepartCode,k.DepartName,k.ParentDepartCode  from tbDeparts k inner join cte c 
6  on c.DepartCode = k.ParentDepartCode 
7  )
8  select * from cte
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/happyqiang/p/11213410.html