What does the `IN` operator do in a SQL WHERE clause?

Advanced SQL Developer Easy

Advanced SQL Developer — Easy

What does the `IN` operator do in a SQL WHERE clause?

Key points

  • `IN` compares a value to a list of values
  • Useful for filtering on multiple specific values
  • Not used for checking null values
  • Different from checking numeric ranges

Ready to go further?

Start full exam Practice more questions

Related questions