Received: from sss.pgh.pa.us (sss.pgh.pa.us [216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4GEa7A08426 for ; Wed, 16 May 2001 10:36:07 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f4GEZvR17172; Wed, 16 May 2001 10:35:58 -0400 (EDT) To: "Marc Sherman" cc: "pgsql-sql List" Subject: Re: Select most recent record? In-reply-to: References: Comments: In-reply-to "Marc Sherman" message dated "Wed, 16 May 2001 09:28:29 -0400" Date: Wed, 16 May 2001 10:35:57 -0400 Message-ID: <17169.990023757@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/161 X-Sequence-Number: 2978 "Marc Sherman" writes: > I'd like to select the newest (max(timestamp)) row for each id, > before a given cutoff date; is this possible? select * from log order by timestamp desc limit 1; regards, tom lane