Hi all,
i have a table as follows
empid empname mgrid deptid
1 a 3 4
2 b 1 5
3 c 2 3
4 d 3 6
5 e 4 7
i want the output as
empname mgrname
a c
b a
c b
d c
e d
Answers were Sorted based on User's Feedback
Answer / gunturajesh
select a.empname empname,b.empname mgrname from emp a,emp b
where a.mgrid=b.empid
Is This Answer Correct ? | 20 Yes | 2 No |
Answer / suresh babu
select t1.empname,t2.empname from emp t1,emp t2 where
t1.mgrid = t2.empid;
This query is self join,Which is display your requirement.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / alok narayan
1.
select empname,(select empname from e1 b
where b.empid =a.mgrid) from e1 a;
2.
select a.empname empname,b.empname mgrname from e1 a,e1 b
where a.mgrid=b.empid order by a.empname ;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nanne saheb c
select e.empname,m.ename mgrname from emp e,emp m
where e.mgrid=m.empid;
Is This Answer Correct ? | 0 Yes | 0 No |
PL/SQL allocates memory for the variable's at runtime or at compile time
What is sql clause?
What is anonymous block in sql?
What does desc stand for?
What is the difference between drop and truncate commands?
how u can find the n row from a table?
Explain table and field in sql?
What is the difference between mdf and ndf files?
how to include comments in sql statements? : Sql dba
With out using count() function. How to the find total number of rows in a table?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What are the syntax and use of the coalesce function?