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
- 7539 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 |
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How will you return the number of records in table?
What is the function of logging in the db2 database?
What is db2 stogroup?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is a clustering index?
What is cursor stability in db2?
What is a DB2 access path?
How to fetch the last row from the table in SQL (db2)?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
COBOL 
