Total members 11889 |It is currently Thu Mar 28, 2024 9:34 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka






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:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 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     -  



cron






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