PostgreSQL BETWEEN Operator

BETWEEN

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.

Example

Select all products with a price between 10 and 15:

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 15;

Run Example »

---

BETWEEN Text Values

The BETWEEN operator can also be used on text values.

The result returns all records that are alphabetically between the specified values.

Example

Select all products between ‘Pavlova’ and ‘Tofu’:

SELECT * FROM Products
WHERE product_name BETWEEN 'Pavlova' AND 'Tofu';

Run Example »

If we add an ORDER BY clause to the example above, it will be a bit easier to read:

Example

Same example as above, but we sort it by product_name:

SELECT * FROM Products
WHERE product_name BETWEEN 'Pavlova' AND 'Tofu'
ORDER BY product_name;

Run Example »

---

BETWEEN Date Values

The BETWEEN operator can also be used on date values.

Example

Select all orders between 12. of April 2023 and 5. of May 2023:

SELECT * FROM orders
WHERE order_date BETWEEN '2023-04-12' AND '2023-05-05';

Run Example »

---

PostgreSQL Exercises

Test Yourself With Exercises

Exercise:

Select all cars where the field year has a value between 1970 and 1980:

SELECT * FROM cars WHERE year ;