Self join for manager relationship
SQL
Easy
2 views
Problem Description
Employees(emp_id, name, manager_id). Show employee name and manager name.
Sample Test Case
Input:
Employees(emp_id, name, manager_id)
Output:
Employee-manager pairs
Official Solution
SELECT e.name AS employee_name, m.name AS manager_name FROM Employees e LEFT JOIN Employees m ON m.emp_id = e.manager_id;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!