Answer Posted / abhijit
The start with .. connect by clause can be used to select
data that has a hierarchical relationship (usually some sort
of parent->child (boss->employee or thing->parts).
select a.*, level from emp a
start with mgr is null
connect by mgr = prior empno;
The start with .. connect by clause can be used to select
data that has a hierarchical relationship (usually some sort
of parent->child (boss->employee or thing->parts).
Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What is the most common sql injection tool?
what tools available for managing mysql server? : Sql dba
Explain the working of primary key?
Explain the types of joins in sql?
what is the difference between join and union? : Sql dba
What are sql constraints?
What is cte sql?
explain primary keys and auto increment fields in mysql : sql dba
How to use distinct and count in sql query? Explain
How to start the command-line sql*plus?
What is sql exception?
How do you update a table in sql?
What is function and procedure?
What is rank function in sql?
What are all the common sql functions?