Page 1 of 1

sql ORDER question

Posted: Wed Oct 16, 2002 4:27 pm
by SL-Cowsrule
Is it possible for me to order things twice?
like:
SELECT * from members ORDER name DESC
then order that?
Do i need to make a temp database to store that information, then order it again, until i like it?

For example:

name age month
Bob 12 11
Joe 17 10
Jill 17 12

How do i order it first by their age (DESC) then by their month?

CoW

Posted: Wed Oct 16, 2002 4:43 pm
by Coco
try:
ORDER BY age, month

or another common example:
ORDER BY Last_name, First_name

[edit, stupid syntax]