How to Use SQL GROUP BY Statement

A SQL GROUP BY statement says that a SQL SELECT query divides result rows into groups depending on one or more columns’ values.

Contents

Use SQL GROUP BY Statement

For each group, grouping is usually utilized to apply some form of the aggregate function. Each group has its own row in the result of a query with a GROUP BY statement.

GROUP BY Syntax
SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
ORDER BY column_name(s);

GROUP BY Clause in SQL

This SQL tutorial includes syntax and examples for using the SQL GROUP BY clause.

Description

In a SELECT statement, the SQL Aggregate BY clause can be used to collect data from several records and group the results by one or more fields.

Syntax

In SQL, the GROUP BY clause has the following syntax:

Arguments or Parameters

Phrases that aren’t present in an aggregation procedure and should be included in the SQL statement’s GROUP BY Clause at the end (expression1, expression2,… expression n).

Aggregate function

The SUM, COUNT, MIN, MAX, or AVG functions are examples of aggregation functions.

Aggregate expression

The aggregate function will be applied to this column or expression.

Tables

The columns out of which you’d like to extract data. At least one table must be mentioned in the FROM clause.

CONDITIONS WHERE These are the criteria that must be met for the recordings to be chosen.
Optional ORDER BY expression The sorting expression for the records in the result set. If there are many expressions, the values should be separated by a comma.
ASC\sOptional. By expression, ASC sorts the result set in ascending order. If no modifier is specified, this is the default behavior.

Examples of DDL/DML

Get the DDL to build the tables and the DML to add the data if you wish to follow along with this tutorial. Then put the samples to the test in your own database!