Multiple choice technology databases

Which operator can be used with a multiple-row subquery?

  1. =

  2. LIKE

  3. BETWEEN

  4. NOT IN

  5. IS

  6. <>
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

NOT IN is a multi-row operator designed to compare a value against a list returned by a multi-row subquery. Operators like =, LIKE, BETWEEN, IS, and <> are single-row operators and will raise a runtime SQL error if the subquery returns multiple rows.

Keep practicing — related questions