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

What is the STOSPACE Utility used for?

1 Answers  


Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,


What is db2 catalog database?

0 Answers  


What does the REORG Utility do?

2 Answers  


what is the difference between where clause and having clause

2 Answers   IBM,






How to check table size in db2 sap?

0 Answers  


What is JOIN and different types of JOIN.

2 Answers   IBM,


what is plan? is plan executable or package?

4 Answers  


If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  


What is the maximum length of sqlca?

0 Answers  


Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,


select 100 records from million records ?

2 Answers   Verizon,


Categories