BETWEEN
The BETWEEN
operator finds values within a given range. The values can be texts, dates, or numbers. Also, this operator is inclusive, i.e., both beginning and ending values are included.
Syntax
SELECT column_name(s)
from table_name
where column_name between value1 and value2;
Note: The basic syntax for
BETWEEN
is generally the same across most databases, but some differences may arise depending on how each database handles specific data types or expressions. To use this operator on a particular database, data handling, null handling, case sensitivity, and collations must be checked first to avoid errors.
Example
Suppose there’s a order_details
table with the following data:
order_id | item | price | quantity | order_date |
---|---|---|---|---|
1 | Donut | 2.49 | 2 | 2022-08-16 08:04:23 |
2 | Cookie | 0.99 | 3 | 2022-08-21 09:43:00 |
3 | Donut | 2.49 | 1 | 2022-08-18 11:25:12 |
4 | Egg Sandwich | 7.99 | 1 | 2022-08-20 11:45:41 |
5 | Ice Coffee | 3.99 | 2 | 2022-08-17 12:18:50 |
Here is a query using the BETWEEN
operator:
SELECT * FROM order_details WHERE order_date BETWEEN '2022-08-15' AND '2022-08-19';
This would return all records from the order_details
table, where the order_date
is between August 15, 2022
and August 19, 2022 (inclusive):
order_id | item | price | quantity | order_date |
---|---|---|---|---|
1 | Donut | 2.49 | 2 | 2022-08-16 08:04:23 |
3 | Donut | 2.49 | 1 | 2022-08-18 11:25:12 |
5 | Ice Coffee | 3.99 | 2 | 2022-08-17 12:18:50 |
All contributors
- Anonymous contributor
Contribute to Docs
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.