How can we find employees and their respective manager, if all employee details available in same table.
DECLARE @EMP TABLE
(
EMPID INT,
EMPName NVARCHAR(100),
ManagerID INT
)
INSERT INTO @EMP
SELECT 1,'Mark',Null UNION ALL
SELECT 2,'Peter',1 UNION ALL
SELECT 3,'Sam',2 UNION ALL
SELECT 4,'Fedrik',2
SELECT E1.EMPName AS 'Employee Name',E2.EMPName AS 'Manager Name' FROM @EMP E1 ,@EMP E2
WHERE
E1.ManagerID = E2.EMPID
No comments:
Post a Comment