I think this one will work Select a.ename as Employee ,b.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 / adil

8 Answers
12158 Views
I also Faced
E-Mail Answers

Answer Posted / adil

I think this one will work
Select a.ename as Employee ,b.ename as Manager from
EMP ,EMP B
where
A.MGR_ID=B.empno

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql query limit?

956

How can we find duplicate records in a table?

924

Can we use view in stored procedure?

886

What are the advantages of indexing?

967

Is it possible to update views?

946

What is query optimization in sql?

964

Which function is used to return remainder in a division operator in sql?

1116

What is cursor in pl sql with examples?

1010

What is group function in sql?

1000

Explain exception handling in pl/sql?

1019

Is pl sql still used?

959

Can we commit in trigger?

952

what are all different types of collation sensitivity? : Sql dba

964

What is a sql instance vs database?

1100

How do I count rows in sql query?

971