IN

How can we match a column against several possible values?

Beginner⏱ 3 Minutes⭐ 590 XP

🤔 THE QUESTION

How can we match a column against several possible values?

💡 WHAT IS IT?

The IN operator checks whether a column value matches any value within a discrete list of literals or subquery results.

🎯 WHAT IS IT USED FOR?

Targeting specific departments, status flags, country lists without repeating multiple OR statements.

💻 EXAMPLE

SELECT name, department
FROM employees
WHERE department IN ('Engineering', 'Analytics', 'Finance');

Practice typing production-grade SQL code for IN.