SQL - BETWEEN

The BETWEEN & AND keywords define a range of data between 2 values.

The BETWEEN syntax looks like this:

SELECT Column1, Column2, Column3, … FROM Table1 WHERE Column1 BETWEEN Value1 AND Value2

The 2 values defining the range for BETWEEN clause can be dates, numbers or just text.

In contrast with the IN keyword, which allows you to specify discrete values in your WHERE criteria, the SQL BETWEEN gives you the ability to specify a range in your search criteria.

We are going to use the familiar Customers table to show how BETWEEN works:

FirstName	LastName	Email	DOB	Phone
John	Smith	John.Smith@yahoo.com	2/4/1968	626 222-2222
Steven	Goldfish	goldfish@fishhere.net	4/4/1974	323 455-4545
Paula	Brown	pb@herowndomain.org	5/24/1978	416 323-3232
James	Smith	jim@supergig.co.uk	20/10/1980	416 323-8888

Consider the following BETWEEN statement:

SELECT * FROM Customers WHERE DOB BETWEEN '1/1/1975' AND '1/1/2004'

The BETWEEN statement above will select all Customers having DOB column between '1/1/1975' and '1/1/2004' dates. Here is the result of this SQL expression:

FirstName	LastName	Email	DOB	Phone
Paula	Brown	pb@herowndomain.org	5/24/1978	416 323-3232
James	Smith	jim@supergig.co.uk	20/10/1980	416 323-8888