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 are set operators in sql? : Sql dba
What does where 1 1 mean in sql?
How do you modify a table in sql?
What is user defined functions?
explain advantages of myisam over innodb? : Sql dba
Is left join same as inner join?
Why do we create views in sql?
What are analytical functions in sql?
how to include numeric values in sql statements? : Sql dba
What is union and union all keyword in sql?
Does sap use sql?
How can we implement rollback or commit statement in a trigger?
What is sequence in sql?
Can we join same table in sql?
What are primary key and foreign key and how they work?
