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:
