select e.ename as employee_name,m.ename as manager

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 / rajesh venati

8 Answers
12512 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is normalization in sql?

1067

What is pl sql commands?

1097

What does closing a cursor do?

1375

What is the non-clustered index in sql?

1108

What is a sql trace file?

1085

What is rowtype?

1081

what is sub-query? : Transact sql

1161

What is user defined functions?

1031

What is not in sql?

999

Why is sql important?

1172

Are there any features that are decommissioned in 11g that are not present in 11g?

2197

What is the difference between inner join and natural join?

1059

What is sql partition function?

1292

what are the limitations of identity column? : Transact sql

1162

What kind of join is join?

1009