SQL 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:

Here is a query using the BETWEEN operator:

SELECT * FROM order_details WHERE order_date BETWEEN '2022-08-15' AND '2022-08-19';

Copy to clipboard
Copy to clipboard

This would return all records from the order_details table, where the order_date is between August 15, 2022 and August 19, 2022 (inclusive):