Home Tutorial Php Sql MySQL Ascending Command

 
 

Share on Google+Share on Google+
MySQL Ascending Command
Posted on: December 9, 2010 at 12:00 AM
Advertisement
This example illustrates how to display the data in the ascending order.

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         |
+-------------+---------------------+

 

Advertisement

Related Tags for MySQL Ascending Command:


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: December 9, 2010

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com