What is a correlated sub query?
Answers were Sorted based on User's Feedback
Answer / guest
Correlated subquery process is an outside-inside-outside
subquery. For every row in the outer query the inner query
is evaluated and results passed to the outer query to
complete the final result row.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / aditya
a query in which there is reference of inner query into
outer query and that of outer query into inner
query...means they can't run independently.
Is This Answer Correct ? | 2 Yes | 1 No |
What is the STOSPACE Utility used for?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is db2 catalog database?
What does the REORG Utility do?
what is the difference between where clause and having clause
How to check table size in db2 sap?
What is JOIN and different types of JOIN.
what is plan? is plan executable or package?
If I have a view which is a join of two or more tables, can this view be updatable?
What is the maximum length of sqlca?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
select 100 records from million records ?