OR Conditions

How can we return employees who satisfy either of two conditions?

Intermediate⏱ 2 Minutes⭐ 570 XP

🤔 THE QUESTION

How can we return employees who satisfy either of two conditions?

💡 WHAT IS IT?

The OR operator returns a row if at least one of the connected conditions evaluates to true.

🎯 WHAT IS IT USED FOR?

Matching multiple departments, broad customer segment querying, multi-status monitoring.

💻 EXAMPLE

SELECT name, department
FROM employees
WHERE department = 'Engineering'
OR department = 'Analytics';

Practice typing production-grade SQL code for OR Conditions.