SQL Server - Find Manager Names of the Employees

SQL Server - Find Manager Names of the Employees

CODE

create table Emp(empid integer, empname varchar(100), managerid integer); insert into Emp values ('1', 'Krishna', null); insert into Emp values ('2', 'Rakesh', '1'); insert into Emp values ('3', 'Rateesh', '1'); insert into Emp values ('4', 'Ajeesh', '1'); insert into Emp values ('5', 'Madhu', null); insert into Emp values ('6', 'Jain', '5'); insert into Emp values ('7', 'Jaya', null); select e.empname, m.empname managername from Emp e left join Emp m on e.managerid = m.empid