self join will accomplish this task.try below query select a.ename,b.ena

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 / john bershan

8 Answers
12159 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the uses of merge?

1150

What is the use of count (*) in sql?

1029

What is the difference between an inner join and an outer join?

1000

What is scalar function in sql?

1016

What are the sql versions?

926

What is rtm in testing?

1089

What is auto increment?

972

How many disk partitions should I have?

974

Is left join and outer join same?

1043

What is using in sql?

1060

What are the three forms of normalization?

1032

How do you change a value in sql?

997

What is set transaction?

1018

What pl/sql package consists of?

1057

what is a view? : Sql dba

1063