Given a table named “Employees” with columns “EmployeeID” and “ManagerID”, write an SQL query to retrieve a list of employees along with their corresponding manager’s name.
Loading
Retrieve Employee and Manager Information
1 Answer
Select e. Employee,e.employeename, m. Employeename as ManagerName from employees e
Left join employees m on m. Managerid=e.employeeid
Nandan HegdePosted Sep 16, 2023, 4:33 PM