Multiple choice technology databases

Which operator allows you to specify multiple values in a WHERE clause?

  1. BETWEEN

  2. IN

  3. HAVING

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

The IN operator lets you test if a value matches any value in a list. For example, WHERE city IN ('Mumbai', 'Delhi', 'Chennai') returns rows where city equals any of those three values. BETWEEN checks for a range, not a list of discrete values.

Keep practicing — related questions