Postgres Pro
Downloads
Home   >   mailing lists

Re: How to re-sort a sorted query? - Mailing list pgsql-sql

From Yudie
Subject Re: How to re-sort a sorted query?
Date
Msg-id 003001c4bc39$dd0470b0$a101a8c0@home.axiontech.com
Whole thread Raw
In response to How to re-sort a sorted query?  ("Yudie" <yudie@axiontech.com>)
List pgsql-sql
Tree view 
> 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
>

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: How do you compare (NULL) and (non-NULL)?
Next
From: Markus Schaber
Date:
Subject: Select Instead on a table