SQL BETWEEN

The SQL BETWEEN operator is used to select data within a range between 2 values.

SQL BETWEEN Operator Syntax

SELECT ColumnName1, ColumnName2, ColumnName3, ...
FROM TableName
WHERE ColumnName BETWEEN Value1 AND Value2

The BETWEEN operator can be used in SQL SELECT, UPDATE, INSERT or DELETE statements; the values can be numbers, text or dates.

SQL BETWEEN Operator Example

Table: Books

Example 1
We want to select books which price between $17.00 and $28.00:

SELECT *
FROM Books
WHERE Price BETWEEN 17 AND 28

For SQL Server, Oracle, mySQL, the result will include the books which price is exactly $17.00 or $28.00, so it will look like:

Example 2
We want to select books which price is out of range of $17.00 and $28.00:

SELECT *
FROM Books
WHERE Price NOT BETWEEN 17 AND 28

The result will look like: