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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between plan and package in db2?
How will you return the number of records in table?
Who uses db2?
Name the lockable units in DB2?
can we view the access paths created by dbrm ? how ? thx
What r the comman abends in db2, jcl and cobol???????
How can you find out the # of rows updated after an update statement?
How to connect to db2 database from windows command line?
What is copy pending status in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is cloudant database?
What is rct?
What is load utility in db2?
What kind of database is db2?
What is the use of db2?