SQL PHP HTML ASP JavaScript articles and free scripts to download
 
 

SQL ORDER BY Descending and ascending Command


The results we get from a table we may have to display in an order. The result may be from highest to lowest or lowest to highest  in a numeric field or from A to Z or Z to A in a text or varchar field.  We may require a combination of this also. We can use ORDER BY sql command to manage the display of records. We will apply this sql command to our student table in MySQL database to control or manage our order of display. Here is the command to display the records in the order of class


SELECT * FROM `student` ORDER BY class

id name class   mark
1 John Deo Four 75
4 Krish Star Four 60
5 John Mike Four 60
6 Alex John Four 55
2 Max Ruin Three 85
3 Arnold Three 55

Here the records are returned in the order by class from A to Z . We can reverse the order by specifying in our sql command to change the order to Descending that is from Z to A. We have to add desc to the ORDER BY clause. Here is the command to do that  


SELECT * FROM `student` ORDER BY class desc


We can apply this to our numeric filed mark to display the list in order of lowest mark to highest mark  by using the ASC command ( ascending command ) . Please note that by default all order by commands are in ascending order only.  Here is the command to display the records in decending order ( from highest to lowest ) based on the mark field.


SELECT * FROM `student` ORDER BY mark desc


Here the total mark will be displayed in the order of highest to lowest and class will not be considered. To display the records in order of mark in a class, we have to use to field names in the order by clause. Here is the code to display the records in the order of class and then in the order of marks. This will give a highly use full way by displaying all the records in order of class and within  the class in order of marks.


SELECT * FROM `student` ORDER BY class desc, mark desc

id name class mark
2 Max Ruin Three 85
3 Arnold Three 55
1 John Deo Four 75
4 Krish Star Four 60
5 John Mike Four 60
6 Alex John Four 55

How to give the option to the user to change the record display order ?
Discuss this tutorial at forum

List of SQL Tutorials


 
Scripts
PHP
JavaScript
HOME
SQL Tutorial List
SQL (Home)
SQL Commands
Subscribe
Submit your email address and receive article and product notifications. Your email is safe with us.