DB2 - SQL BETWEEN Operator

The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.

The BETWEEN operator is inclusive: begin and end values are included.

Syntax:

SELECT column_name(s)
  FROM table_name
  WHERE column_name BETWEEN value1 AND value2;

DB2 Database:

Below is a selection from the "Product" table in the DB2 database.

Example 1:

The following SQL statement selects all products with a price BETWEEN 10 and 50:

SELECT * FROM Product
  WHERE Price BETWEEN 10 AND 50;

Result:

Example 2:

The following SQL statement selects all products outside the range of the previous example, use NOT BETWEEN::

SELECT * FROM Products
  WHERE Price NOT BETWEEN 10 AND 50;

Result:

If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!