SQL OR Operator – Filter Any Condition with Examples (2026-27)

✅ What is the SQL OR Operator?

✅ The SQL OR operator is a logical operator used inside a WHERE clause to filter rows.

✅ It combines two or more conditions — a row appears in results if ANY ONE condition is true.

✅ Unlike AND, which requires all conditions to be true, OR only requires at least one to be true.

✅ Sample Employees Table:-

✅ SQL OR Syntax

SELECT column1, column2, ...
FROM table_name
WHERE condition1 OR condition2 OR condition3 ...;

✅ SELECT:- Columns you want to retrieve.

✅ FROM:- The table to query data from.

✅ WHERE:- Starts the filtering section.

✅ OR:- Joins conditions — if ANY ONE is true the row is returned.

✅ Example – IT Department OR HR Department

Retrieve all employees who work in either the IT or HR department.

✅ SELECT Query:-

SELECT * FROM Employees
WHERE Department = 'IT' OR Department = 'HR';

✅ Result:-

✅ Example – City is Pune OR City is Mumbai

Retrieve all employees located in either Pune or Mumbai.

✅ SELECT Query:-

SELECT * FROM Employees
WHERE City = 'Pune' OR City = 'Mumbai';

✅ Result:-

SUJAN from Delhi is excluded — Delhi matches neither condition. Everyone else qualifies because their city is either Pune or Mumbai.

✅ Example – Three OR Conditions

You can chain as many OR conditions as you need. Any one condition being true is enough for the row to be included.

✅ SELECT Query:-

SELECT * FROM Employees
WHERE Department = 'IT'
  OR Department = 'HR'
  OR Department = 'Sales';

✅ Result:-

✅ Example – OR Combined with AND

You can mix OR and AND in one query. Always use parentheses to group OR conditions — this prevents unexpected logic errors.

✅ SELECT Query:-

SELECT * FROM Employees
WHERE (Department = 'IT' OR Department = 'HR')
  AND Salary > 7000;

✅ Result:-

✅ OR vs AND – Key Differences

✅ Key Points to Remember

✅ ANY ONE condition being true is enough — OR is permissive. One true condition includes the row.

✅ Chain as many OR conditions as needed — WHERE A OR B OR C OR D is valid SQL.

✅ Text values need single quotes — WHERE City = 'Pune' not = Pune.

✅ Use parentheses when mixing OR + AND — prevents logic errors.

✅ AND evaluates before OR — without parentheses A OR B AND C means A OR (B AND C).

✅ Consider IN as an alternative — WHERE City IN ('Pune','Mumbai','Delhi') replaces multiple OR conditions on the same column.

✅ OR works with all data types — text, numbers, dates, boolean.

✅ Common SQL OR Mistakes to Avoid