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
- 8801 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
Can sql developer connect to db2?
What is server name sql?
How do I use google cloud in sql?
What is trigger explain with example?
What is the use of %rowtype?
Does mysql_real_escape_string prevent sql injection?
What is the use of primary key?
What is varchar example?
Difference between truncate, delete and drop commands?
Can we insert in sql function?
What is parameter substitution in sql?
what are the advantages of using stored procedures? : Sql dba
What is a clob in sql?
What is the difference between left join and right join?
how do you control the max size of a heap table? : Sql dba
