Question

what is the use of group by and order by clause in mysql​

Answer 1

Answer:

the MYSQL GROUP bg clause is used to collect data from multiple records... and group the result by one or more column... it is generally used in a select statement

Answer 2

Answer:

The MYSQL GROUP BY Clause is used to collect data from multiple records and group the result by one or more column. It is generally used in a SELECT statement.

You can also use some aggregate functions like COUNT, SUM, MIN, MAX, AVG etc. on the grouped column.