What is a correlated sub query?

Answers were Sorted based on User's Feedback



What is a correlated sub query?..

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

What is a correlated sub query?..

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

Post New Answer

More DB2 Interview Questions

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,


What are the disadvantages of PAGE level lock?

3 Answers  


How do I create a view in db2?

0 Answers  


What is a base table?

2 Answers  


insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,






Can we install 2 different versions of Db2 on same mainframe?

3 Answers  


How many clustering indexes can be defined for a table?

2 Answers  


What are db2 tables?

0 Answers  


What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  


How do you check for a null value in a db2 column?

2 Answers  


What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,


What are concurrency issues?

0 Answers  


Categories