A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.
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
Can you have a foreign key without a primary key?
What are inner and outer joins examples of both?
Write a sql query to convert all character to uppercase after hypen.
What is your daily office routine?
What are the different types of triggers?
How do you select unique values in sql?
Why do we use function in pl sql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How do you explain an index number?
What are the types of join in sql?
what is the difference between blob and text? : Sql dba
What are the various levels of constraints?
How much does sqlite cost?
What is the difference between jpql and sql?
What is embedded sql in db2?