PostgreSQL Group By

In today’s article, we will be learning the GROUP BY command, which allows us to perform operations by grouping columns.

GROUP BY also has functions such as sum() and count().

I will do the examples in this article using the address table in the pagila database.

You can use the link below to download the Pagila database.

https://dbtut.com/index.php/2018/10/28/how-to-install-postgresql-sample-database/

1	https://dbtut.com/index.php/2018/10/28/how-to-install-postgresql-sample-database/

We will list how many records are in the same district using the Address table.

SELECT count(district),district 
FROM address
GROUP BY district

SELECT count(district),district

FROM address

GROUP BY district

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux