Saturday, January 6, 2024

Query to get the Employee name and their Manager name from the same table in SQL Server

Query to get the Employee name and their manager's name from the same table in SQL Server
 
Below is Employee Table 

SELECT e.employeename, m.employeename AS ManagerName FROM Employee e JOIN Employee m ON e.ManagerId = m.EmployeeId 





No comments:

Post a Comment