NOT IN

How can we exclude several values from our results?

Beginner⏱ 3 Minutes⭐ 600 XP

🤔 THE QUESTION

How can we exclude several values from our results?

💡 WHAT IS IT?

NOT IN filters out records whose column values match any entry in a given exclusion set.

🎯 WHAT IS IT USED FOR?

Excluding specific departments, filtering out banned accounts, omitting inactive statuses.

💻 EXAMPLE

SELECT name, department
FROM employees
WHERE department NOT IN ('HR', 'Finance');

Practice typing production-grade SQL code for NOT IN.