On Thu, May 25, 2006 at 14:30:05 -0700,
> Bruno, no worries. i didn't explain what i wanted too
> well. i'm *only* interested in the last (latest
> timestamp) inspect_result for each inspect_id.
Then DISTINCT ON is the the simplest way to do this. You can ORDER BY
inspect_id DESC, timestamp DESC to get the last record for each inspect_id.
This is not standard SQL though.
In response to
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2006-05-25 21:56:51|
|Subject: Re: SQL Question - S/B Good...|
|Previous:||From: operationsengineer1||Date: 2006-05-25 21:30:05|
|Subject: Re: SQL Question - Almost, Not Quite...|