What is a correlated sub query?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List down the data types in the db2 database.

631


Is db2 a mainframe?

581


Is it possible using max on a char column?

599


What is the physical storage length of timestamp data type?

640


What are host variables in db2?

621






What is query_cache_limit?

541


What is ibm db2 client?

517


How to create backup table in db2?

640


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7501


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1574


What is a page in db2?

608


What is a db2 collection?

603


What is the difference between cursor and select statement?

609


What is the reason behind not using select * in embedded sql programs?

601


What is the syntax for FETCH in DB2 ?

671