What is correlated sub-query?

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


Please Help Members By Posting Answers For Below Questions

Does sql full backup truncate logs?

510


What is sql resultset?

505


What are all different types of collation sensitivity?

509


What is a temporal data type?

573


Is left join faster than inner join?

570






What is the difference between rollback and rollback to statements?

558


how to extract a unit value from a date and time? : Sql dba

529


What is basic structure of pl sql?

473


How do I edit a trigger in sql developer?

518


What is exit statement?

521


What is delimiter in pl sql?

567


What are the 3 types of behavioral triggers?

629


Can dml statements be used in pl/sql?

550


What do you know by pl/sql cursors?

535


What is a variable in sql?

486