Re: Order by question

[Thomas Kellerer <spam_eater@xxxxxxx>]

Kevin Kempter wrote on 26.11.2008 20:46:
> Hi All;
>
> I'm selecting 3 columns.  I want to order the results ascending by col1 and 
> col2 and then descending by col3
>
> Whats the syntax for this?

ORDER BY col1 ASC, col2 ASC, col3 DESC

this is documented in the manual


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general