In this article, we will learn how to use the BETWEEN operator with a SQL select query.

The BETWEEN operator is used to select values within a given range, begin and end values are also included in that. The values can be numbers, strings, or dates.

Syntax

SELECT column_name(s)
FROM TABLE_NAME
WHERE column_name BETWEEN value1 AND value2;

Example-1

The subsequent statement would return all articles with an ID BETWEEN 3 AND 7.

SELECT * FROM Article
WHERE ID BETWEEN 3 AND 7;

Example-2

The subsequent statement would return all articles without an ID BETWEEN 3 AND 7.

SELECT * FROM Article 
WHERE ID NOT BETWEEN 3 AND 7;

 

Also, check How To Use IN, NOT IN Operator In SQL