EXISTS Operator Returns TRUE if subquery returns at least one row - SQL Operations
Q. Which Operator Returns TRUE if a subquery returns at least one row?- Published on 03 Jul 15a. EXISTS
b. IN
c. IS NULL
d. LIKE
ANSWER: EXISTS
The EXISTS condition is used by a subquery and is considered if the subquery atleast returns one row.