Re: How to re-sort a sorted query?

From: "Yudie" <yudie(at)axiontech(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How to re-sort a sorted query?
Date: 2004-10-27 15:30:15
Message-ID: 003001c4bc39$dd0470b0$a101a8c0@home.axiontech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> select * from
> (select distinct on (storenumber), itemsku, storenumber,price
> from storeproduct where itemsku='10001'
> order by storenumber, price) ss
> order by price;
>
> regards, tom lane

Thanks tom, this is working. I never thought it could be done like this.

yudie

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2004-10-27 15:36:43 Re: How do you compare (NULL) and (non-NULL)?
Previous Message Jon Uhal 2004-10-27 15:09:39 Foreign Key Non-Null Problem in 8.0