The MariaDB SQL GROUP BY clause is used in the SELECT statement to group the SQL query result into one or more columns. For the result set with same values, we can use the GROUP BY clause to summarized to values and display the result as we want.

In this tutorial, you will learn how to use the GROUP BY clause In MySQL SQL statement. We will walkthrough the "GROUP BY" syntax with detailed explantions and examples.

The GROUP BY clause Syntax

The syntax of a GROUP BY clause is as follows:

---

Parameters Explanations

column_name

table_name

condition

---

Example - Using GROUP BY with the SUM Function

In this tutorial, we will use the well-known Northwind sample database for demonstration purpose. Below is a portion of data selected from the orders table:

customer_id	ship_name	ship_city	shipping_fee
4	Christina Lee	New York	5
8	Elizabeth Andersen	Portland	50
4	Christina Lee	New York	4
8	Elizabeth Andersen	Portland	5
10	Roland Wacker	Chicago	9
10	Roland Wacker	Chicago	0
8	Elizabeth Andersen	Portland	50
4	Christina Lee	New York	5
8	Elizabeth Andersen	Portland	50
4	Christina Lee	New York	4
8	Elizabeth Andersen	Portland	5
10	Roland Wacker	Chicago	9
10	Roland Wacker	Chicago	0
8	Elizabeth Andersen	Portland	50
4	Christina Lee	New York	0

Here is the example of selecting from the orders table and group by the ship_name



The result is:

ship_name	total_shipping_fee
Christina Lee	18
Elizabeth Andersen	210
Roland Wacker	18

In the above example, we have used the GROUP BY clause to select the total shipping fee and group by the shipper name from the table: orders.

Example - Using GROUP BY clause with the COUNT Function

Besides the SUM function, we can also use the COUNT function in the GROUP BY clause. Consider to use the orders

Let's issue the following SQL with the COUNT function



The result is:

customer_id	total_ship
4	5
8	6
10	4

In the above example, we have use the GROUP BY clause with the COUNT Function to select the total ship associated with each customer id in the orders table.