Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Write only the SQL statement that solves the problem and nothing else.
- With EmployeeCTE (id, managerId, name)
- AS
- (
- SELECT id, managerId, name
- FROM employees
- WHERE managerId is NULL
- UNION ALL
- SELECT employees.id, employees.managerId, employees.name
- FROM employees
- JOIN EmployeeCTE
- on employees.managerId = EmployeeCTE.id
- )
- SELECT EmpCTE.name AS Employee
- FROM EmployeeCTE EmpCTE
- JOIN EmployeeCTE MgrCTE
- ON EmpCTE.managerId = MgrCTE.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement