Interested to Buy Any Domain ? << Click Here >> for more details...
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 port does sql server use?
What is sql and how does it work?
Which table is left in join?
what are the performance and scalability characteristics of mysql? : Sql dba
What is a natural join sql?
What is linq to sql?
Does view contain data?
Enlist the characteristics of pl/sql?
Can we create table in function?
What are dml commands?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What are different joins used in sql?
How do I filter in sql profiler?
Who is the owner of mysql database?
Which one is better sql or oracle?
