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 is a SQL operator that compares a value to EVERY value returned by a subquery. For example, 'salary > ALL (SELECT salary FROM employees)' means the salary must be greater than every salary in the subquery results. IN checks membership in a set, ANY checks if the condition is true for at least one value, and OF is not a comparison operator.

Keep practicing — related questions