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
- 7457 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 to check table size in db2 sap?
Which command is used to remove all rows from a table?
What is the difference between nvl and coalesce?
What is bind and rebind in db2?
What is the reason behind not using select * in embedded sql programs?
What do you mean by storage group (stogroup)?
Where do you specify them?
What is the physical storage length of time data type?
Explain the contention situations caused by locks?
Can there be more than one cursor open for any program?
Can we insert update delete in view?
What is buffer pool in the db2 database?
What is the picture clause of null indicator variable?
What is a trigger in the db2 database?
What db2 400?
