select empno,ename from emp start with mgr

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

8 Answers
12283 Views
I also Faced
E-Mail Answers

Answer Posted / monika

select empno,ename
from emp
start with mgr_id is null
connect by prior empno=mgr_id;

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the sql commands?

1187

Is the primary key an index?

1028

Explain clause in sql?

1034

what are the type of locks ? : Sql dba

967

What is the difference between an inner and outer join?

1020

Define sql delete statement.

1016

What is a natural join?

1078

how can we submit a form without a submit button? : Sql dba

995

What is the use of index in hive?

1007

How to find 3rd highest salary of an employee from the employee table in sql?

1083

Do stored procedures prevent sql injection?

971

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4015

Can you rollback after commit?

995

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2031

What is oracle pl sql developer?

987