# BETWEEN Operator in SQL

BETWEEN Operator in SQL helps you select values withing a given range.

#### Syntax of BETWEEN operator –

SELECT column_name
FROM table_name
WHERE column_name BETWEEN value1 AND value2

Let’s say that I want to find all the orders where the price of an item is between 5 to 10 dollars.

SELECT *
FROM orderitems
WHERE item_price BETWEEN 5 AND 10;

And to get all the orders that are not between 5 and 10 dollars

SELECT *
FROM orderitems
WHERE item_price NOT BETWEEN 5 AND 10;

Rating: 1 out of 5.