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
- 8710 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
Why do we use partitions in sql?
What is query syntax?
What is ttitle and btitle?
What is the maximum rows in csv?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is a database? Explain
what is the difference between myisam static and myisam dynamic? : Sql dba
What are the types of join in sql?
How can we make an if statement within a select statement?
How does postgresql compare to oracle/db2/ms sql server/informix?
Can cursors be part of a trigger body?
Which data dictionary views have the information on the triggers that are available in the database?
Explain what is a view?
what is isam? : Sql dba
What are the different types of sql commands?
