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

The ALL operator compares a scalar value to every value produced by a subquery, requiring the condition to hold for each row. IN checks membership, ANY (or SOME) checks against at least one row, and OF is not an SQL operator, making ALL the right choice.

Keep practicing — related questions