What is correlated subquery?
Answer / s
Correlated subquery refers to atleast one column of the
outer query. The correlated subquery is evaluated for each
qualifying row from the outer query.
| Is This Answer Correct ? | 1 Yes | 0 No |
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
How many clustering indexes can be defined for a table?
What is the physical storage length of time data type?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is the picture clause of null indicator variable?
what is the use of cursors?
Could anyone clearly explain the diference between sub query and correlated sub query?
What is explain plan in db2?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
Define db2 and its databases?
What is precompiler in db2?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.