PostgreSQL Having
The PostgreSQL HAVING is used with a GROUP BY clause and returns records where aggregate values meet the specified conditions.
Having syntax
SELECT column_name1, column_name2, function(column_name1) FROM table_name GROUP BY column_name1, column_name2 HAVING function(column_name1) operator value
Having example
Goods table
| id | good_type | name | description | price |
|---|---|---|---|---|
| 1 | A | Car_1 | Car 1 description | 100 |
| 2 | A | Car_2 | Car 2 description | 200 |
| 3 | A | Car_3 | Car 3 description | 100 |
| 4 | B | Boat_4 | Boat 4 description | 500 |
| 5 | B | Boat_5 | Boat 5 description | 300 |
| 6 | C | Train_1 | Train 123 description | 800 |
SELECT good_type, count(good_type) g_count FROM goods GROUP BY good_type HAVING count(good_type) > 1
Result
| good_type | g_count |
|---|---|
| B | 2 |
| A | 3 |