SQL Cheat Sheet/Filter with BETWEEN

Filter a value within an inclusive range.

Section: Filtering Rows

Filter with BETWEEN

sql
sql
SELECT *
FROM events
WHERE created_at BETWEEN DATE "2025-01-01" AND DATE "2025-01-31";
Explanation

BETWEEN is inclusive on both ends in standard SQL.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Filtering Rows
Filter with equality
Return rows matching an exact value.
OpenIn sheetsqlsame section
Use comparison operators
Compare numeric or date values.
OpenIn sheetsqlsame section
Filter with IN
Match any value from a list.
OpenIn sheetsqlsame section
Pattern matching with LIKE
Find rows using wildcard patterns.
OpenIn sheetsqlsame section
Test for NULL
Filter rows with missing values.
OpenIn sheetsqlsame section
Select all columns
Return all columns from a table.