To get manager name based on managerid and emp id IN SQL

SELECT * from empdetails 

SELECT  e.empid,e.empname,m.empname as managername

fROM  empdetails e left join empdetails m

on e.managerid = m.empid

TableName - empdetails