Finding who is whose manager from the give table. I have given the reqired table and resultant table below. Give query for SQL server 2005

Question

------------------
ID    Name     Mgr
------------------
1    Ajay      4
2    Vijay     5
3    Nayeem    1
4    Rakesh    3
5    Varun     4
6    Bhupesh   1
-----------------

I want the result as

-----------------
Name     Mgr
-----------------
Ajay     Rakesh
Vijay    Varun
Nayeem   Ajay
Rakesh   Nayeem
Varun    Rakesh
Bhupesh  Ajay

Answer 1

Select sub.name , sup.name 
from yourtab sub
join yourtab sup
on sup.id = sub.mgr

;