What is the purpose of a subquery in DB2?

To create indexes on a table
To group data in a table
To nest one query within another query to retrieve data based on the results of the inner query
To perform aggregate functions on a table

A subquery in DB2 allows you to nest one query within another query to retrieve data based on the results of the inner query. This helps in fetching data conditionally based on the results of another query.

Add your answer