Click here to Skip to main content
15,915,702 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Empid   Empname    Managerid

   1       A           Null
   2       B            1
   3       C            2
   4       D            1
   5       E           
   6       F            3


i want to write the query using self join and find out for Each empname who is manager id using query in sql server

What I have tried:

Empid   Empname    Managerid

   1       A           Null
   2       B            1
   3       C            2
   4       D            1
   5       E           
   6       F            3


i want to write the query using self join and find out for Each empname who is manager id using query in sql server
Posted
Updated 14-Oct-17 19:19pm
v2

1 solution

Try:
SQL
SELECT a.EmpName, b.EmpName FROM MyTable a
JOIN MyTable b ON a.ManagerID = b.EmpId
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900