DECLARE @tmp as Table(ID int,EmpName varchar(10),ManagerID int)
INSERT INTO @tmp SELECT 1,'Kiran',null
INSERT INTO @tmp SELECT 2,'Stephen',1
INSERT INTO @tmp SELECT 3,'Basha',2
INSERT INTO @tmp SELECT 4,'Surya',3
SELECT
t1.*,
t2.EmpName ManagerName
FROM @tmp t1
LEFT JOIN @tmp t2
ON t1.ManagerID = t2.ID