Postgres Pro
Downloads
Home   >   mailing lists

Re: Select most recent record? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Select most recent record?
Date
Msg-id 17169.990023757@sss.pgh.pa.us
Whole thread Raw
In response to Select most recent record?  ("Marc Sherman" <msherman@projectile.ca>)
Responses RE: Select most recent record?  ("Marc Sherman" <msherman@projectile.ca>)
List pgsql-sql
Tree view 
"Marc Sherman" <msherman@projectile.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

pgsql-sql by date:

Previous
From: Srikanth Rao
Date:
Subject: Restricting the number of decimal digits
Next
From: Andrew Perrin
Date:
Subject: Re: Select most recent record?