Question: What is the requirement for using a subquery in the SELECT clause?

1. the subquery must use an aggregate function.
2. the subquery must refer to the same table as the main query.
3. the subquery must return a single value.
4. the subquery must return at least one value.

Answer: The correct answer of the above question is Option C:the subquery must return a single value.