SQL ORDER BY

You can sort the selected results using ORDER BY command, for instance :

Code:

SELECT * FROM 'Department' ORDER BY name

The results in the previous query will be in a ascending order (from A to Z), you can reverse the order direction by adding desc to the query.

Code:

SELECT * FROM 'Department' ORDER BY name desc

You can use it for numeric values :

Code:

SELECT * FROM 'Department' ORDER BY DepId desc

You can sort records with more than one column to handle the case with records have similar values in one column:

Code:

SELECT * FROM 'Department' ORDER BY name,DepId desc

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : SQL ORDER BY
Difference in order between HashSet and ArrayList -
Return an array with elements in reverse order -
Input three numbers and then sort non descending order -
rank order filter effects on image -
How to change the default order on forums from ascending to -
How to display WooCommerce customer order details -
SELECT-Group by and Order by,Having Clause,count(),Joins -

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com