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
What normalization means?
What are procedures used for?
What does the argument [or replace] do?
What is the main reason behind using an index?
What is asqueryable?
Does pdo prevent sql injection?
What is the difference between function, procedure and package in pl/sql?
what is bcp? When does it used? : Sql dba
what are enums used for in mysql? : Sql dba
What are the possible values for the boolean data field?
What are different categories of sql commands?
What is sql prepared statement?
What is the difference between inner join and natural join?
What is time based sql injection?
What is where clause in sql?