i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example
empno ename mgr_id
1 john 3
2 paul 3
3 smith 1
4 kevin 1
5 stewart 2
result has to look like this
ename manager
john smith
paul smith
smith john
kevin john
stewart paul
can u plz help me out in this.....
Answers were Sorted based on User's Feedback
Answer / praveen h
I think this one will work
Select a.ename as Employee ,b.ename as Manager from
EMP ,EMP B
where
A.MGR_ID=B.empno
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / rajesh venati
select e.ename as employee_name,m.ename as manager_name from
emp e, emp m where e.mgr_id=m.empno;
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / cbigmudre
select a.ename, b.enanme as manager
from emp as a, emp as b
where a.empno = b.mgr_id
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / karthik
select e1.empno,e1.ename EmpName,e2.ename MgrName from emp e1,emp e2
where e1.mgr_id=e2.ename(+);
select e1.empno,e1.ename EmpName,e2.ename MgrName
from emp e1 left outer join emp e2
where e1.mgr_id=e2.ename;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudhan
select e1.ename EmpName,e2.ename MgrName from emp e1,emp e2
where e1.mgr_id=e2.ename;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / john bershan
self join will accomplish this task.try below query
select a.ename,b.ename as manager from emp a,emp b
where a.empno = b.mgrid;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / monika
select empno,ename
from emp
start with mgr_id is null
connect by prior empno=mgr_id;
Is This Answer Correct ? | 0 Yes | 2 No |
Which is faster joins or subqueries?
What is the difference between drop and truncate commands?
Which join is default?
What do you mean by stored procedures?
What is rtm in testing?
How can I pass the inner procedure value to outer procedure ?
What is pl sql architecture?
What is string join?
Is it possible for a table to have more than one foreign key?
Why do we use cursors?
what are the differences between char and varchar? : Sql dba
Why do we use function in pl sql?