How does the processing of a correlated subquery differ
from a non correlated subquery?
- 1 Answers
- 7603 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
what is the process of precompiler?
How does coalesce work?
How do you eliminate duplicate values in db2?
What is an intent lock?
How do I import a csv file into db2?
How would you find out the total number of rows in a db2 table?
Describe major components of db2?
How to find primary key of a table in db2?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
how to fetch multiple records without using cursor
wht is d/f between union and joins ?
COBOL 
