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
12156 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 is difference between left and right outer join?

966

What is mdf ldf and ndf?

975

What are the different set operators available in sql?

1009

what is an extent ? : Sql dba

1070

what are all the common sql function? : Sql dba

1041

What does rownum mean in sql?

1008

How to load data with sql*loader?

1032

How do temporal tables work?

934

What is the life of an sql statement?

999

What are the uses of merge?

1150

What is a left inner join?

991

Why do we use partitions in sql?

1032

what is a join? : Sql dba

1008

What is sql analyzer?

995

What is the benefit of foreign key?

1006