Order By MySQL

Tutorials

Mysql

Topic

How to sort Table using MySQL Order By Clause ?

Explanation

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.

mysql> select name, marks from student order by marks;
+---------+-------+
| name    | marks |
+---------+-------+
| michael |    75 |
| steve   |    75 |
| anne    |    80 |
| jack    |    82 |
| david   |    98 |
| mille   |    98 |
| steve   |   100 |
| anne    |   100 |
+---------+-------+
8 rows in set (0.03 sec)

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


mysql> select name, marks from student order by marks desc;
+---------+-------+
| name    | marks |
+---------+-------+
| steve   |   100 |
| anne    |   100 |
| david   |    98 |
| mille   |    98 |
| jack    |    82 |
| anne    |    80 |
| michael |    75 |
| steve   |    75 |
+---------+-------+
8 rows in set (0.00 sec)

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