Re: Select most recent record?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc Sherman" <msherman(at)projectile(dot)ca>
Cc: "pgsql-sql List" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Select most recent record?
Date: 2001-05-16 14:35:57
Message-ID: 17169.990023757@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Marc Sherman" <msherman(at)projectile(dot)ca> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Perrin 2001-05-16 14:43:22 Re: Select most recent record?
Previous Message Srikanth Rao 2001-05-16 13:34:54 Restricting the number of decimal digits