Re: [GENERAL] Order by question

[Thomas Kellerer]

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general