When running an SQL query that uses EXISTS,the EXISTS keyword will be true if ________.
A)any row in the subquery meets the condition
B)all rows in the subquery meet the condition
C)no row in the subquery meets the condition
D)any row in the subquery fails to meet the condition
E)all rows in the subquery fail to meet the condition

Question

Quizplus · Accepted Answer

The EXISTS keyword will be true if any row in the subquery meets the condition. It does not require all rows to meet the condition or that no rows meet the condition. It only requires at least one row to meet the condition.

When Running an SQL Query That Uses EXISTS,the EXISTS Keyword