select a.ename, b.enanme as manager from emp as a, emp as b where a.empno

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.....

Question Posted / cbigmudre

8 Answers
11929 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the differences between implicit and explicit cursors?

1004

Can one improve the performance of sql*loader? : aql loader

983

Can we use update in sql function?

1010

Explain the structure of pl/sql in brief.

1044

Is it possible to pass parameters to triggers?

1032

How do I create a memory optimized filegroup?

906

What are hotfixes and patches?

889

Explain table and field in sql?

1016

How do you delete data from a table?

976

how is exception handling handled in mysql? : Sql dba

1009

Mention what does plv msg allows you to do?

1053

What is difference between inner join and self join?

1030

What is cross join example?

942

What is sharding in sql?

919

What is the left table in sql?

915