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
Does sql full backup truncate logs?
What is sql resultset?
What are all different types of collation sensitivity?
What is a temporal data type?
Is left join faster than inner join?
What is the difference between rollback and rollback to statements?
how to extract a unit value from a date and time? : Sql dba
What is basic structure of pl sql?
How do I edit a trigger in sql developer?
What is exit statement?
What is delimiter in pl sql?
What are the 3 types of behavioral triggers?
Can dml statements be used in pl/sql?
What do you know by pl/sql cursors?
What is a variable in sql?