GROUP BY statements
pgAdmin and PostgreSQL
Paul Jozefek
2021-05-08
Aggregation
Most Common Aggregate Functions
| Function | Result |
|---|---|
| AVG() | returns average value |
| COUNT() | returns number of values |
| MAX() | returns maximum value |
| MIN() | returns minimum value |
| SUM() | returns the sum of all values |
GROUP BY statement
GROUP BY will allow you to aggregate data by a categorical variable.
HAVING statement
HAVING allows you to filter after an aggregation has taken place.
