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
- 7540 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
What is with ur in db2?
what is the sqlcode -501
What is host variable in db2 cobol?
What parameters are used to control the free space in DB2?
What is the default page size of buffer pools?
Define db2 and its databases?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Why select is not preferred in embedded sql programs?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How do I change the column size in db2?
What does runstats do in db2?
What is a bind in db2?
Can we delete records from view?
Explain db2.
What is table space in db2?
