PostgreSQL Between

PostgreSQL Between

The PostgreSQL BETWEEN returns rows between two values from a select query.

Between syntax

SELECT * FROM table_name WHERE column_name BETWEEN x_value AND y_value;

Between example

Goods table

id good_type name description price insert_date
1 A Car_1 Car 1 description 100 2018-07-21 08:45:57.311809
2 A Car_2 Car 2 description 200 2018-07-21 08:45:57.311809
3 A Car_3 Car 3 description 100 2018-07-21 08:45:57.311809
4 B Boat_4 Boat 4 description 500 2018-07-21 08:45:57.311809
5 B Boat_5 Boat 5 description 300 2018-07-21 08:45:57.311809
6 C Train_1 Train 123 description 800 2018-07-21 08:45:57.311809
SELECT * FROM goods WHERE price between 300 and 800;

Result

id good_type name description price insert_date
4 B Boat_4 Boat 4 description 500 2018-07-21 08:45:57.311809
5 B Boat_5 Boat 5 description 300 2018-07-21 08:45:57.311809
6 C Train_1 Train 123 description 800 2018-07-21 08:45:57.311809