postgresHow to group resulting set by specific column values
SELECT first_name, COUNT(*) FROM person GROUP BY first_name;ctrl + cCOUNT(*)aggregate function that returns the number of rows | GROUP BY first_namegroup the result set by first_name |
More of Postgres
- How to select unique (distinct) values from column
- Create Table
- How to use aliases
- How to use AND / OR operators
- How to filter resulting set after grouping is done
- Order By
- How to select column which value is between two values
- Where
- How to filter column based on multiple values
See more codes...