EmpID EmpName ManagerId 1 Viraj 6 2 Yatin 1 3 Ravi 6 4 Nikunj 3 5 Bhavesh 3 6 Viral 6 7 Mukesh 8 8 Nilesh 6
EmpName ManagerName Viraj Viral Yatin Viraj Ravi Viral Nikunj Ravi
select e1.empid,e1.empnm,e2.empnm as ManagerNm from emptbl e1 left join emptbl e2 on e1.ManagerId = e2.EmpId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)