How does the processing of a correlated subquery differ
from a non correlated subquery?
- 1 Answers
- 6954 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 |
Is it possible to precompile if db2 goes down?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is db2 connect?
What is PRIME TABLE and what are the uses of it
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What do you mean by storage group (stogroup)?
What techniques are used to retrieve data from more than one table in a single SQL statement?
What type of database is db2?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
What is a base table?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
COBOL 
