When a multiple-column subquery is included in the WHERE or HAVING clause of the outer query,which operator is used by the outer query to evaluate the results of the subquery?
A)
B) BETWEEN
C) IN
D) none of the above

Question

When a multiple-column subquery is included in the WHERE or HAVING clause of the outer query,which operator is used by the outer query to evaluate the results of the subquery?​
A) ​>
B) ​BETWEEN
C) ​IN
D) ​none of the above

Quizplus · Accepted Answer

When using a multiple-column subquery in the WHERE or HAVING clause, the IN operator is used by the outer query to evaluate the results of the subquery. The IN operator is used to compare a column to a set of values returned by a subquery.

When a Multiple-Column Subquery Is Included in the WHERE or HAVING