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
- 7427 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 can the firstname and the lastname from the emp table be concatenated to generate complete names?
What do you mean by NOT NULL? When will you use it?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What do you mean by storage group (stogroup)?
what is cursor stability?
What os does db2 run on?
What is a bind card?
How do you define a correlated name?
In terms of DB2 indexing, what is the root page?
What techniques will be used to avoid deadlock??
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
COBOL 
