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
- 7436 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 create a view in db2?
What is null indicator in db2?
What is image copy in db2?
How would you find out the total number of rows in a db2 table?
Explain correlated sub-queries.
How can we retrieve the total number of records in RPG & CLLE?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Explain about open switch business continuity software?
How to view db2 table structure?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is null in db2?
What is a plan and package in db2?
What is a cursor in programming?
Is db2 a mainframe?
What is a bind in db2?
