Filtering & Conditions
Refine your queries with powerful filtering and conditional logic.
🎯
Beginner5 topics
DISTINCT
Collapse duplicate rows into unique values
Beginner 8m
IN Operator
Check a value against a list — cleaner than chained ORs
Beginner 9m
BETWEEN
Filter values within a range — inclusive on both ends
Beginner 8m
LIKE & Pattern Matching
Search text with wildcard patterns — partial matches, prefixes, suffixes
Beginner 10m
CASE WHEN
Add if-then-else logic directly inside your queries
Intermediate 14m