Leetcode Problem 1270. All People Report to the Given Manager

1270. All People Report to the Given Manager

Leetcode Solutions

Start with a recursive CTE that selects all employees who directly report to the head of the company (excluding the head themselves).
Recursively join the CTE with the Employees table on manager_id to find employees who indirectly report to the head.
Continue the recursion until no more indirect reports are found or the maximum level of hierarchy (three managers) is reached.
Select the employee_id from the final recursive CTE to get the list of all employees who report directly or indirectly to the head of the company.
Return the result in any order.


erDiagram
    Employees {
        int employee_id
        varchar employee_name
        int manager_id
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen