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
Are dml statements autocommit?
Show code of a cursor for loop.
How do sql triggers work?
What is a delimiter in sas?
How do I enable sql encryption?
What is dynamic query?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is meant by user defined function?
What does varchar include?
How to create an array in pl/sql?
What does data normalization mean?
What is break?
Can a primary key be a foreign key?
What is the current version of postgresql?
What is the main reason behind using an index?
