SQL Query for find manager with in the same name

 Table 

Query 

select e.Emp_Name,m.Emp_Name as Manager from EmpDetails e 

left join EmpDetails m on m.Manager_Id=e.id