ASA SQL User's Guide
  Queries: Selecting Data from a Table
    The WHERE clause: specifying rows

Using ranges (between and not between) in the WHERE clause

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

To list all the products with prices between $10 and $15, inclusive

• Type the following query:

  SELECT name, unit_price
  FROM product
  WHERE unit_price BETWEEN 10 AND 15

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

To list all the products cheaper than $10 or more expensive than $15

• Execute the following query:

  SELECT name, unit_price
  FROM product
  WHERE unit_price NOT BETWEEN 10 AND 15