Re: [SQL] ids from grouped rows

[Ragnar Hafstað]

On Wed, 2005-07-20 at 08:46 -0400, Lindsay wrote:

> SELECT name, MAX(age), id_for_row_with_max_age
> FROM Person
> GROUP BY name

how about:
  select distinct on (name) name, age, id 
         from person
         order by name, age desc;



gnari

 



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster