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 |
how to copy the host variables from ps file into cobol program other than include statement
What are the disadvantages of PAGE level lock?
How do I create a view in db2?
What is a base table?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
Can we install 2 different versions of Db2 on same mainframe?
How many clustering indexes can be defined for a table?
What are db2 tables?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How do you check for a null value in a db2 column?
What technique is used to retrieve data from more than one table in a single SQL statement?
What are concurrency issues?