The EXISTS operator must be listed ____
A) on the left side of the comparison operator
B) on the right side of the comparison operator
C) in the SELECT clause
D) none of the above

Question

The EXISTS operator must be listed ____​
A) ​on the left side of the comparison operator
B) ​on the right side of the comparison operator
C) ​in the SELECT clause
D) ​none of the above

Quizplus · Accepted Answer

The EXISTS operator is used in SQL to test for the existence of any record in a subquery. It does not fit into the categories of being on the left or right side of a comparison operator, nor is it used in the SELECT clause. It is used in a WHERE clause.

The EXISTS Operator Must Be Listed ____​

The EXISTS Operator Must Be Listed ____