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 a plan and package in db2?
What is the difference between spufi and qmf?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
Suppose if I need to update a column, how you do that using cursor?
What is subquery ?
What is read-only cursor?
What is usage pointer in cobol?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is db2? Explain.
What type of database is db2?
What is difference between alias and synonym in db2?
What's the maximum number of volumes that can be added to a STOGROUP?