递归CTE祖先(具有多个经理的员工)

WITH RECURSIVE cte_name (column_list) AS (
    -- 初始查询
    SELECT column_list FROM table_name WHERE condition
    UNION ALL
    -- 递归查询
    SELECT column_list FROM table_name JOIN cte_name ON join_condition
)
SELECT * FROM cte_name;

WITH RECURSIVE ancestors (employee_id, manager_id) AS (
    -- 初始查询：找到具有多个经理的员工
    SELECT employee_id, manager_id FROM employees
    WHERE employee_id IN (
        SELECT employee_id FROM employees
        GROUP BY employee_id
        HAVING COUNT(DISTINCT manager_id) > 1
    )
    UNION ALL
    -- 递归查询：找到祖先
    SELECT e.employee_id, e.manager_id
    FROM employees e
    JOIN ancestors a ON e.employee_id = a.manager_id
)
SELECT * FROM ancestors;