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

how to see the create table statement of an existing table? : Sql dba

1019

What is parallel hint?

1328

Does oracle use sql?

931

What is column?

992

What is the difference between left join and right join?

946

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1073

Differentiate pl/sql and sql?

1070

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4289

how many tables will create when we create table, what are they? : Sql dba

1076

What is clause?

1152

Can %notfound return null after a fetch?

1060

How many clustered indexes can be created on a table?

1075

What is the use of index in sql?

1017

How do you explain an index number?

1110

What is informix sql?

980