Re: find the greatest, pick it up and group by

When asking for help on non-trivial SELECT queries it really helps to tell
us the version of PG you are using so that responders know what
functionality you can and cannot use. In this case specifically, whether
WINDOW (and maybe WITH) clauses available?

David J.

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Ivan Sergio Borgonovo
> Sent: Monday, May 16, 2011 7:39 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] find the greatest, pick it up and group by
>
>
> I'd like to group by idordine, grupposped, idart.
> For every row grouped that way, I'd like to pick the greatest of the
> q* columns and insert:
> idordine, grupposped, idart, name of the greatest(q*) in a new table.
> I don't mind if more than one q* column is equal to greatest(q*). It
should
> pick up one, just one no matter which among the one equal to greatest(q*).
>
> I think this way works but it hurts my eyes. Any alternative approach?
>