Order By MySQL

Order By MySQL :

We can also sort multiple columns in different directions as given in the below MySQL Order by query.

Example :

Here we have selected three columns name, marks and address. In this query we have sorted the column name alone in ascending order and we have additionally mentioned marks in descending order.
So if there are same names, the highest mark will be taken as the first priority. In the above example query, there are 2 anne, so the anne with highest mark will be displayed first.