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
12524 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 are procedures used for?

1038

What are pl/sql cursor exceptions?

1168

What is compiled query?

1089

What are stored procedures used for?

1054

What is the difference between clustered and non-clustered index in sql?

1069

What is spool?

1111

How long it takes to learn pl sql?

1069

what is index? : Sql dba

1045

Name three sql operations that perform a sort.

1066

How do I add a database to sql?

1187

What is sql*plus?

1122

how do you know the version of your mysql server? : Sql dba

1051

What is an example of translating a date into julian format?

1211

What is the use of primary key?

1049

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1149