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 database manager in db2?
Normalization in DB2 – first normal form, second normal form
How can you quickly find out the # of rows updated after an update statement?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is dpf in db2?
How do I optimize a query in db2?
What is the use of with ur in db2?
Explain about dbrm.
What is DCLGEN?
What is the database descriptor?
What is the difference between primary key & unique index ?