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
- 7345 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 |
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
How to run db2 command in windows?
Differentiate between cs and rr isolation levels? Where do you specify them?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is PRIME TABLE and what are the uses of it
What is referential integrity?
How to fetch the uncommited data from table ?
What is meant by union and union all?
Which component is used to execute the sql statements?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
What is reorg and runstats in db2?
Can any one tell me about Restart logic in DB2.
COBOL 
