Re: [GENERAL] SELECT DISTINCT ON and ORDER BY

[Volkan YAZICI]

On Fri, 28 Mar 2008, Sam Mason <[EMAIL PROTECTED]> writes:
> On Fri, Mar 28, 2008 at 01:12:49PM +0100, Stanislav Raskin wrote:
>> The result in this case should be:
>> 
>> id value  order_field
>> 3   10      1
>> 5   12      2
>> 4    5      8

Yet another lame solution:

test=# SELECT max(id) AS id, min(value) AS value, min(weight) AS weight
         FROM tmp
        GROUP BY value
        ORDER BY min(weight);
 id | value | weight
----+-------+--------
  3 |    10 |      1
  5 |    12 |      2
  4 |     5 |      8
(3 rows)


Regards.

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