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
- 8596 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
How much does sqlite cost?
What is bulk collect in pl sql?
What is the difference between joins?
Is sql open source?
Write a sql query to convert all character to uppercase after hypen.
Can we have two clustered index on a table?
What is difference between pls_integer and integer?
what is online transaction processing (oltp)? : Sql dba
What is mutating trigger?
How do you change a value in sql?
How do you go back in sql?
which tcp/ip port does sql server run on? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba
Explain lock escalation? : Transact sql
How can I see all tables in sql?
