Database Managment - Sql

Back to Course

Lesson Description

Lession - #1314 Sql Group By Clause

The GROUP BY statement groups rows that have same values in row, similar to


"track down the quantity of clients in every country".

The GROUP BY explanation is frequently utilized with functions ( COUNT(>
, MAX(>
, MIN(>
, SUM(>
, AVG(>
to set the outcome set by at least one columns.

Syntax for Group By Clause

SELECT column1, column2
FROM table_name
WHERE [ conditions ]
GROUP BY column1, column2
ORDER BY column1, column2


Online compiler