Interested to Buy Any Domain ? << Click Here >> for more details...
A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.
- 2 Answers
- 8708 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
what is 'mysqld'? : Sql dba
what is rdbms? : Sql dba
what are all the different normalizations? : Sql dba
What is insert command in sql?
Can we connect to postgresql using sql developer?
What is meant by <> in sql?
How do you change a value in sql?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is mutating sql table?
Why is sharding used?
what is a join? : Sql dba
Explain what is an index?
Why left join is used in sql?
What are the various restrictions imposed on view in terms of dml?
What does data normalization mean?
