Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: about ORDER BY (newbie here)

Re: about ORDER BY (newbie here)

From: <jdorlon_at_my-deja.com>
Date: Wed, 07 Feb 2001 15:17:07 GMT
Message-ID: <95rota$g6o$1@nnrp1.deja.com>

or if you don't want to type so much, just do this :

order by 1,2 <- where 1 and 2 represent column numbers (numbering starts with 1, not 0)

you can also do something like this to mix things up a bit :

order by 1 desc, 2

Sent via Deja.com
http://www.deja.com/ Received on Wed Feb 07 2001 - 09:17:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US