How does the processing of a correlated subquery differ
from a non correlated subquery?
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 |
When is the results table for the query in a DECLARE CURSOR statement created?
What is the difference between TYPE 1 index & TYPE 2 index
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is the difference between oracle and db2?
What is a correlated sub query?
How can you display the current date & current time ?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
Is ibm db2 open source?
What Utility is used to migrate DB2 from one release to the next?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
On which levels locks can be applied?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.