Difference between orderby and groupby in mysql

The following is a detailed analysis of the difference between orderby and groupby in mysql. For more information, see orderby in English. Orderby must be followed by multiple field names. Groupby is a group in English. Aggregate functions are required.

The following is a detailed analysis of the differences between order by and group by in mysql. For more information, see order, the default value is ascending. Order by must be followed by multiple field names. Group by is a group in English. Aggregate functions are required.

The following describes the differences between order by and group by in mysql.

In English, order by is the sort of rows. The default value is ascending. Order by must be followed by multiple field names.
Group by is a group in English. You must have an aggregate function. At least one group flag field is required for use.
What is an aggregate function "?
For example, sum (), count (), and avg () are all "Aggregate functions"
The purpose of using group by is to classify and summarize data.