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
- 7325 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 are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is a collection?
What is the use of runstats in db2?
What is the use of db2?
Why do chiropractors use drop table?
What is role in db2?
Where could you look if you had a question about whether a column has been defined as an index?
wht are the restrictions for union ?
Explain about open switch business continuity software?
Why select is not preferred in embedded sql programs?
What is copy pending and check pending in db2?
What is the STOSPACE Utility used for?
COBOL 
