JZTXT

【LeetCode1270. 向公司CEO汇报工作的所有人】with recursive找到某节点所有的后代

发布时间 2023-08-18 08:34:48作者: yhm138

题目地址

https://leetcode.cn/problems/all-people-report-to-the-given-manager/description/

代码

WITH RECURSIVE cte_subordinates AS (
    -- 基础情况: 找到直接下属
    SELECT employee_id 
    FROM Employees 
    WHERE manager_id = 1
    UNION
    -- 递归情况: 找到下属的下属
    SELECT t.employee_id 
    FROM Employees  t
    INNER JOIN cte_subordinates s ON t.manager_id = s.employee_id
)
SELECT employee_id FROM cte_subordinates
where employee_id <>1