Multiple choice technology databases

Which of the following is not a multiple-row operator?

  1. IN

  2. OF

  3. ALL

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

IN, ALL, and ANY are all valid multiple-row operators in SQL that can compare a value to results returned by a subquery. IN checks if a value exists in the subquery results, while ALL and ANY compare a value against every value in the subquery results. OF is not a SQL operator and certainly not a multiple-row comparison operator.

Keep practicing — related questions