Q10. Which three statements are true regarding single row subqueries?
- (A). They must be placed on the right side of the comparison operator or condition.
- (B). They must be placed on the left side of the comparison operator or condition.
- (C). They can be used in the where clause.
- (D). A SQL statement may have multiple single row subquery blocks.
- (E). They must return a row to prevent errors in the SQL statement.
- (F). They can be used in the having clause.
Answer: C,D,F