Multiple choice technology databases

Which operator compares a value to every value returned by a subquery?

  1. IN

  2. OF

  3. ALL

  4. ANY
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ALL operator compares a value to EVERY value returned by a subquery. For example, salary > ALL (subquery) means salary is greater than the maximum value in the subquery. ANY compares to at least one value, IN checks for membership, and OF is not a valid operator.

Keep practicing — related questions