X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 876A7529A4 for ; Wed, 20 Jul 2005 11:47:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90213-04 for ; Wed, 20 Jul 2005 14:47:07 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id 03BEE5293E for ; Wed, 20 Jul 2005 11:47:05 -0300 (ADT) Received: from adsl7-107-122.du.simnet.is ([85.220.103.122] [85.220.103.122]) by quasar.skima.is with ESMTP; Wed, 20 Jul 2005 14:47:08 Z Subject: Re: ids from grouped rows From: Ragnar =?ISO-8859-1?Q?Hafsta=F0?= To: Lindsay Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Wed, 20 Jul 2005 14:50:12 +0000 Message-Id: <1121871013.17734.9.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/175 X-Sequence-Number: 22153 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