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
- 7445 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 |
How is the SUBSTR keyword used in sql?
How to resolve -805 error in DB2?
What is db2 command?
Can you search give an array in the WHERE clause of a db2 query?
What is meant by AUTO COMMIT?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
How Plan is created while executing the query using SPUFI?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
Define predicate?
What if we fail to give values in columns declared as NOT NULL ?
What is the command used by TSO users to invoke DB2?
What does db2 plan contain?
COBOL 
