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!