What & Why
Logical operators (AND, OR, NOT) are used to combine multiple conditions in a WHERE clause. Business filters usually contain multiple rules. Logical operators let you express those rules precisely without running several separate queries.
See how it works
Marketing wants active campaigns for either SMB or enterprise segments.
SELECT
name,
channel,
target_segment
FROM marketing.campaigns
WHERE status = 'active'
AND target_segment IN ('smb', 'enterprise');
Syntax pattern
See explanation
WHERE condition_a
AND (condition_b OR condition_c)
- AND means every condition must be true.
- OR means at least one condition can be true.
- Parentheses make mixed AND/OR logic explicit.
Now You Try
Practice this concept hands-on
Run SQL against real datasets right here in the browser and get instant AI feedback. Join the waitlist to get access.
Join the waitlist