Find All Reports Under a Manager (n-level) and Return Hierarchy Path (SQL)

You have an organization table organization(employee_id, manager_id, name).

Find all employees who report to manager_id = 1, including both direct and indirect reports (n levels deep).

**Require...

Example

Unlock to view complete problem details

and practice with sample input/output

Was this article helpful?

View Test Cases & Run Code requires membership

Standard Input
Execution Result: