Home > mailing lists

Re: Order by question - Mailing list pgsql-general

From	Grzegorz Jaśkiewicz
Subject	Re: Order by question
Date	November 26, 2008 18:59:52
Msg-id	2f4958ff0811261159y7ce2648va45abe5b0510a863@mail.gmail.com Whole thread Raw
In response to	Order by question (Kevin Kempter <kevink@consistentstate.com>)
List	pgsql-general

On Wed, Nov 26, 2008 at 7:46 PM, Kevin Kempter <kevink@consistentstate.com> wrote:

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?

select * from foo order by a,b asc, c desc;

--
GJ

From: Kevin Kempter
Date: 26 November 2008, 18:53:15
Subject: Order by question

From: Andreas Kretschmer
Date: 26 November 2008, 19:00:52
Subject: Re: Order by question