What is GROUP BY statement in MySQL

Question

Hi!!

Can someone tell me what is GROUP BY statement in MySQL?

Answer 1

This statement is used with the aggregate functions to group the result-set by one or more columns.

Syntax:

SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
ORDER BY column_name(s);