Loading

using self join get the output for below table

narasiman rao

9y824

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Poonam Bhosale8y ago
Hi Narasiman,
Following query is about finding Empid and Empname who is manager using self join.

select distinct a.Empid , a.Empname from Manager a , Manager b
where a.Empid = b.Managerid
0
Khaja Moizuddin9y ago
Hey instead of asking to community , you can try on your own , by refering the below link
http://www.c-sharpcorner.com/article/easiest-way-to-understand-joins-in-sql-server/

In this i have mentioned all the joins with examples.
0