In this article You will learn, group by clause is used to group the results of a SELECT query based on one or more columns. It is also used with SQL functions to group the result from one or more tables.
Syntax
SELECT column_name, function(column_name)
FROM table_name
WHERE condition
GROUP BY column_name
Example
SELECT name, age
FROM Employee GROUP BY salary
Group by
in a Statement with WHERE
clauseSELECT name, salary
FROM Employee
WHERE age > 29
GROUP BY salary
2020-05-07