Order By MySQL

Order By MySQL :

In the preceding examples, the query for selected rows are displayed in no particular order. We can also select the rows to display in an ordered format using ORDER BY Clause.
The following example query will sort the rows in an ascending order based on the marks.

Example :

We can also sort the orders in descending order. In the below example query the marks are sorted in descending order.

Example :

Next we can see how to sort the multiple columns.
These examples helps you to use the order by mysql query.