sqlserver with 递归 

WITH DepartmentTemp as (
    SELECT * FROM Departments WHERE deptName='分销一中心'
    UNION ALL 
    SELECT a.* FROM Departments a,DepartmentTemp b WHERE a.parentID=b.deptID
)  
SELECT * FROM DepartmentTemp
posted @ 2022-02-17 15:45  laluckystar  阅读(82)  评论(0)    收藏  举报