Tutorial for SQL Keyword BETWEEN - u3schools

SQL BETWEEN

SQL BETWEEN keyword allows to select a range of data from the table. The syntax for the BETWEEN statement is given below :

SELECT "column_name"
FROM "table_name"
WHERE "column_name" BETWEEN 'value1' AND 'value2'

let us assume the below table as a price information for a book shop. Table name is price_information.

Example 1:

Executed Query:

SELECT *
FROM price_information
WHERE Date BETWEEN 'AUG-10-2009' AND 'Aug-16-2009'

Result:

Description:
The query will returns the result which is comes under the given date range.

Example 2:

Executed Query:

SELECT *
FROM price_information
WHERE sales_price BETWEEN '$10' AND '$15'

Result:

Description:
The query will returns the result which is comes under the given price range $10 to $.15.

Example 3:

Executed Query:

SELECT *
FROM price_information
WHERE serial_no BETWEEN 2 AND 5

Result:

Description:
The query will returns the result which is serial_no value comes under 2 to 5.