Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

PostgreSQL GROUP BY Clause


GROUP BY

The GROUP BY clause groups rows that have the same values into summary rows, like "find the number of customers in each country".

The GROUP BY clause is often used with aggregate functions like COUNT(), MAX(), MIN(), SUM(), AVG() to group the result-set by one or more columns.

Example

Lists the number of customers in each country:

SELECT COUNT(customer_id), country
FROM customers
GROUP BY country;
Run Example »

GROUP BY With JOIN

The following SQL statement lists the number of orders made by each customer:

Example

SELECT customers.customer_name, COUNT(orders.order_id)
FROM orders
LEFT JOIN customers ON orders.customer_id = customers.customer_id
GROUP BY customer_name;
Run Example »

PostgreSQL Exercises

Test Yourself With Exercises

Exercise:

List the number of customers in each country:

SELECT (customer_id), country FROM customers
;
        

Start the Exercise