select manager name,employee name,level from table

A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.

Question Posted / sharad kumar

2 Answers
8593 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / sharad kumar

select manager name,employee name,level
from table_name
start with manager name is null /* optional*/
connect by prior nocycle employee name = manager name
/*Child = Parent */

Is This Answer Correct ?

20 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does t sql mean?

895

How many subqueries can be nested in a statement?

930

Is sql harder than python?

1036

How many postgresql users are there, worldwide?

989

What happens when a trigger is associated to a view?

839

Is sql considered coding?

990

Can we write dml inside a function in sql server?

896

what is a composite primary key ? : Sql dba

996

What is the basic structure of an sql?

1031

What are types of indexes in sql?

1005

Is and as keyword in pl sql?

899

What is pessimistic concurrency control? : Transact sql

1023

What is loop in pl sql?

978

What is a boolean in sql?

943

define sql delete statement ? : Sql dba

969