MySQL Ascending Command

This example illustrates how to display the data in the ascending order.

In this example, the below table shows the data of the 'emp' table in ascending order. To sort a result, use an ORDER BY clause, default sort order is ascending. In the below table shows the name field in the ascending order.

Query

SELECT ASCII(name), name FROM emp order by name;

Output

+-------------+---------------------+
| ASCII(name) | name                |
+-------------+---------------------+
| 97          | amardeep patel      |
| 97          | amit raghuvanshi    |
| 97          | anusmita            |
| 100         | deepak mohanty      |
| 103         | girish tewari       |
| 103         | govind              |
| 104         | hardeep             |
| 107         | komal choudhary     |
| 110         | noor                |
| 114         | rakesh              |
| 114         | ravikant sachan     |
| 115         | sandeep kumar suman |
| 115         | santosh kashyap     |
| 115         | saurabh             |
| 115         | suman saurabh       |
| 118         | vikash              |
| 118         | vineet bansal       |
| 118         | vinod kumar         |
+-------------+---------------------+

Related Tags for MySQL Ascending Command:

«Previous Index Next»

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics