SQL Group By

SQL Group By

The SQL GROUP BY is used when at least one of the aggregation functions is used in a select query.
The aggregate functions are: count, max, min, sum, avg.

Group By syntax

SELECT column_name1, column_name2, function(column_name1)
FROM table_name
GROUP BY column_name1, column_name2

Group By example

Coder books table

SELECT id, title, price, count(price) p_count
FROM coder_books
GROUP BY id, title, price

Result

SELECT price, count(price) p_count
FROM coder_books
GROUP BY price
HAVING count(*) > 0

Result