SQL BETWEEN Function
Quick summary: The SQL BETWEEN operator filters values within a range (inclusive).
SQL BETWEEN Syntax
WHERE column_name BETWEEN value1 AND value2SQL
SQL BETWEEN Basic examples
SELECT * FROM orders WHERE total BETWEEN 100 AND 200;SQL
Output:
Orders with totals from 100 to 200Includes both boundary values.
SQL BETWEEN Real-world usage
SELECT * FROM events WHERE created_at BETWEEN '2026-01-01' AND '2026-01-31';SQL
Output:
January eventsFilters date ranges.
SQL BETWEEN Edge cases
SELECT * FROM numbers WHERE value BETWEEN 5 AND 5;SQL
Output:
Rows where value equals 5BETWEEN is inclusive.
SQL BETWEEN Common mistakes
Using BETWEEN with timestamps
End date may exclude late values.
Incorrect
BETWEEN '2026-01-01' AND '2026-01-31'Correct
>= '2026-01-01' AND < '2026-02-01'Use half-open intervals.
SQL BETWEEN Frequently Asked Questions
What does BETWEEN do in SQL?
Filters values within a range (inclusive).
Use case of BETWEEN?
Range queries.
Syntax?
column BETWEEN value1 AND value2.
Inclusive?
Yes.
Common mistake?
Assuming exclusive range.
Works with dates?
Yes.
Works with numbers?
Yes.
Performance?
Good with indexes.
Alternative?
>= AND <=.
Supports NOT BETWEEN?
Yes.
Used with WHERE?
Yes.
Best practice?
Ensure correct boundaries.