Interested to Buy Any Domain ? << Click Here >> for more details...
How does the processing of a correlated subquery differ
from a non correlated subquery?
- 1 Answers
- 7466 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
For every qualifying row in the outer query the correlated
subquery is evaluated. The correlated subquery has
reference to atleast one column of the outer query.
Non-correlated subquery does not make any reference to the
other query. The subquery is only executed once and the
results are used by the outer query to find the qualifying
rows.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How do I start db2 in windows?
What is package in db2 mainframe?
What is dbrm?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What are union and union all?
Differentiate between cs and rr isolation levels? Where do you specify them?
what is utility for parm lib
What is rebind in db2?
What is runstats and reorg in db2?
Can one database have multiple instances?
How is a typical db2 batch pgm executed?
What is the default page size of buffer pools?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is db2 stogroup?
Where can you declare a cursor in a cobol-db2 program?
