Rathrola Prem Kumar
Retrieve Employee and Manager Information

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.

By Rathrola Prem Kumar in SQL on Aug 21 2023
  • Nandan Hegde
    Sep, 2023 16

    Select e. Employee,e.employeename, m. Employeename as ManagerName from employees e Left join employees m on m. Managerid=e.employeeid

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS