What is the purpose of a correlated subquery in DB2?

  • To filter the result set
  • To perform a calculation
  • To perform an aggregate calculation
  • To reference columns from the outer query
A correlated subquery is used to reference columns from the outer query within the subquery. This allows the subquery to be evaluated once for each row processed by the outer query, enabling more complex filtering and calculations. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *