Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
select empno,ename from emp where deptno in(
select deptno from dept where dept.deptno=emp.deptno)
when inner subquery has an reference to outer query then
this is know as Correlated sub-query.
| Is This Answer Correct ? | 107 Yes | 23 No |
Post New Answer View All Answers
Can we join more than 2 tables in sql?
What are the packages in pl sql?
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
Do we need to rebuild index after truncate?
Difference between truncate, delete and drop commands?
What do you understand by pl/sql records?
What does trigger mean in slang?
What are stored procedures used for?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
what is commit? : Sql dba
What is sqlcontext?
Whis is not false in primary key?
Is natural join same as inner join?
what are different types of collation sensitivity? : Sql dba
What is a design view?
