[Home]  [Edit this page]  [Recent Changes]  [Special Pages]  [Help
SqlOrderBy

(SQL) ORDER BY

You can sort data by using ORDER BY.

-- Select the oldest women from the database
SELECT * FROM DATABASE
  WHERE GENDER = 'FEMALE'
  ORDER BY AGE


You can make the sort descending by adding DESC:

-- Select the youngest women from the database
SELECT * FROM DATABASE
  WHERE GENDER = 'FEMALE'
  ORDER BY AGE DESC


Code links



last edited (November 3, 2006) by bilderbikkel, Number of views: 1310, Current Rev: 2 (Diff)

[Edit this page]  [Page history]  [What links here]  [Discuss this topic]  [Printer Friendly]  

Members

Username:

Password:


Register
Forgot Password?




Programmers Heaven - for .NET, Java, C/C++ and WEB Developers!
© 1996-2008 Community Networks Ltd. All rights reserved. Reproduction in whole or in part, in any form or medium without express written permission is prohibited. Violators of this policy may be subject to legal action. Please read Terms Of Use and Privacy Statement for more information. Development by Tore Nestenius at .NET Consultant - Synchron Data.