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 |