BETWEEN

Anonymous contributor's avatar
Anonymous contributor
Published Oct 7, 2024
Contribute to Docs

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

Contribute to Docs

Learn SQL on Codecademy