Question

What is the meaning of the "GROUP BY" clause in Mysql?  

Options

• Group data by column values

• Group data by row values

• Group data by column and row values

• None of the

Answer 1

Group data by column values

Explanation:

Find the number of consumers in each county using the GROUP BY statement aggregates rows with the same values into summary rows.

The COUNT(), MAX(), MIN(), SUM(), and AVG() aggregate functions are frequently used with the GROUP BY statement to group the result set by one or more columns.