To create a condition that is true if one or more rows are obtained when the subquery is executed, you can precede that subquery with which operator?
A) IS NULL
B) IS TRUE
C) IS EXIST
D) EXISTS

Question

Quizplus · Accepted Answer

The EXISTS operator is used in SQL to test for the existence of any record in a subquery. If the subquery returns one or more records, the condition is considered true.

To Create a Condition That Is True If One or More