A table was given with 3 columns like Manager id,Manager Name and Employee name

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
7747 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

Answer / sankar

select manager name,employee name,level from table_name
start with manager_name is null/* optional */ connect by prior
no cycle employee name=manager name/*child=parent*/

Is This Answer Correct ?

1 Yes

0 No

Post New Answer