select e1.empno,e1.ename EmpName,e2.ename MgrName from emp e1,emp e2 where

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 / karthik

8 Answers
12261 Views
I also Faced
E-Mail Answers

Answer Posted / karthik

select e1.empno,e1.ename EmpName,e2.ename MgrName from emp e1,emp e2
where e1.mgr_id=e2.ename(+);

select e1.empno,e1.ename EmpName,e2.ename MgrName
from emp e1 left outer join emp e2
where e1.mgr_id=e2.ename;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can variables be used in sql statements?

1031

What is the need of a partition key?

987

What are different types of queries in sql?

1121

How do you determine the current isolation level? : Transact sql

1158

Why join is faster than subquery?

1112

What is dml and ddl?

959

what is the different between now() and current_date()? : Sql dba

1022

What are data types in pl sql?

1142

define sql update statement ? : Sql dba

1121

what is the difference between blob and text? : Sql dba

1020

How to assign sql query results to pl sql variables?

1079

What is pl/sql language case sensitive?

1125

Define SQL and state the differences between SQL and other conventional programming Languages?

1211

What steps server process has to take to execute an update statement?

975

What is the use of prepared statement?

1022