Home Sql Mysql-example MySQL ASC
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

MySQL ASC

Advertisement
Executing select query with order by clause returns the rows in the order of column name specified with the order by clause.

MySQL ASC

     

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

Executing select query with order by clause returns the rows in the order of column name specified with the order by clause. By default, the data is returned in ascending order. But you can explicitly mention the order of the result by ASC keyword. ASC determines that the results will be shown in ascending order. If you want the order in descending order then use DESC keyword.

In this example, select query displays data in ascending order of name.

 

 

 

 

Query
SELECT * FROM employee ORDER BY name ASC;
Output
+----+--------+----------------------+
| id | name   | designation          |
+----+--------+----------------------+
| 1  | Ajay   | programmer           |
| 3  | Kamal  | sr. graphic designer |
| 7  | Karan  | programmer           |
| 5  | Nitin  | content writer       |
| 8  | Rajesh | graphic designer     |
| 4  | Rajiv  | graphic designer     |
| 6  | Sachin | programmer           |
| 2  | Vinay  | programmer           |
+----+--------+----------------------+
Advertisement

Liked it!  Share this Tutorial


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: April 3, 2006

Ask Questions?    Discuss: MySQL ASC  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com