**Structured Query Language** (SQL) has a multitude of operators that allow for flexible queries. These ensure that the most accurate results are obtained. 

The **`BETWEEN`** operator allows for the selection of values in a given range. For example, suppose you want data on your teenage customers. To do this, you could easily run an SQL query that uses the `BETWEEN` operator to fetch only those records in which the age lies between 13 and 19. `BETWEEN` is inclusive, which means that the beginning and end values are also included in the range.

#   
## Syntax

SELECT columnName
FROM tableName
WHERE columnName BETWEEN a AND b;

The beginning and end values can be numbers, text, or dates.
Let's look at an example.

#   
## Code
### Demo table 'Inventory'

align-center

Run the code below to get products that have a price between 10 and 12 dollars.

CREATE TABLE Inventory (
    p_ID int,
    p_name varchar(255),
    p_price int,
    s_ID int,
    p_number int
);

INSERT INTO Inventory
VALUES (1,'Apple',12,1,120);
INSERT INTO Inventory
VALUES (2,'Orange',10,1,105);
INSERT INTO Inventory
VALUES (3,'Banana',8,2,90);
INSERT INTO Inventory
VALUES (4,'Mango',15,3,95);
INSERT INTO Inventory
VALUES (5,'Peach',14,1,115);

SELECT * FROM Inventory
WHERE p_price BETWEEN 10 AND 12;

How to use the BETWEEN operator in SQL

Syntax

Code

Demo table ‘Inventory’

p_ID	p_name	p_price	s_ID	p_number
1	Apple	12	1	120
2	Orange	10	1	105
3	Banana	8	2	90
4	Mango	15	3	95
5	Peach	14	1	115