...

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

Example:

"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






Example:



Online compiler