Could anyone clearly explain the diference between sub
query and correlated sub query?
Answer Posted / sriram
Correlated subquery runs once for each row selected by the
outer query. It contains a reference to a value from the
row selected by the outer query.
Nested subquery runs only once for the entire nesting
(outer) query. It does not contain any reference to the
outer query row.
For example
Correlated Subquery:
select e1.empname e1.basicsal e1.deptno from emp e1 where
e1.basicsal (select max(basicsal) from emp e2 where
e2.deptno e1.deptno)
Nested Subquery:
select empname basicsal deptno from emp where (deptno
basicsal) in (select deptno max(basicsal) from emp group by
deptno)
Please let me know if I am wrong...............
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can deadlocks be resolved?
Is db2 a mainframe database?
What is an instance database?
Is ibm db2 free?
What are db2 objects?
What is db2 bind?
What is the result of open cursor statement?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is consistency token in db2?
What is commit in db2?
What is the purpose of rollback and commit?
What is the picture clause of null indicator variable?
What is precompiler in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
On which levels locks can be applied?