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
- 7320 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 you pull up a query which was previously saved in qmf?
What is the clustering index in the db2 database?
What is bind and rebind in db2?
what is the sqlcode -501
What is concurrency?
Define declaration generator (dclgen).
what is the responsibility of the construction superintendent
How to view db2 table structure?
What is a db2 schema?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Mention the various locks that are available in db2.
What is db2 connect?
When the like statement is used?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is phantom read in db2?
