Ranges in the WHERE clause

The BETWEEN keyword specifies an inclusive range, in which the lower value and the upper value and the values they bracket are searched for.

You can use NOT BETWEEN to find all the rows that are not inside the range.

The following query lists all the products with prices between $10 and $15, inclusive.

SELECT Name, UnitPrice
   FROM Products
   WHERE UnitPrice BETWEEN 10 AND 15;

The following query lists all the products less expensive than $10 or more expensive than $15.

SELECT Name, UnitPrice
   FROM Products
   WHERE UnitPrice NOT BETWEEN 10 AND 15;