MySQL ORDER BY clause

1. Syntax: Select field list from table name [WHERE clause][group by clause][having clause][order by clause];

Annotations:

1. The default is to start with the first record ascending,

2.desc is descending from the first record

3.order by the back can be followed by the aggregation function

Example:

1. Check the average salary for each city and sort in descending order

Statement: Select City,avg (Salary) from student group by City order by AVG (salary) desc;

Annotations:

1. You can sort by using multiple fields at the same time, preferably by specifying a collation when sorting. The first field can compare the results, then the second field is not considered, otherwise the second field value is compared when the first field value is equal.

MySQL ORDER BY clause