【LeetCode1270. 向公司CEO汇报工作的所有人】with recursive找到某节点所有的后代
题目地址
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