A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.
- 2 Answers
- 8149 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
Explain table and field in sql?
What is sequence in sql?
What is rownum and rowid?
What is sql in java?
What is the difference between left join and right join?
what are date and time functions in mysql? : Sql dba
What is the use of function in sql?
What is left join in sql?
How does a self join work?
How do sql triggers work?
What are the disadvantages of file system?
What is the basic structure of an sql?
Which is faster view or stored procedure?
What is lexical units in pl sql?
How can you view the errors encountered in a trigger?
