Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: SQL Question - Almost, Not Quite...
- From: Bruno Wolff III <bruno(at)wolff(dot)to>
- To: operationsengineer1(at)yahoo(dot)com
- Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
- Subject: Re: SQL Question - Almost, Not Quite...
- Date: Thu, 25 May 2006 16:56:46 -0500
On Thu, May 25, 2006 at 14:30:05 -0700, operationsengineer1(at)yahoo(dot)com wrote: > > 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.
- References:
- Re: SQL Question - Almost, Not Quite...
- From: Bruno Wolff III
- Re: SQL Question - Almost, Not Quite...
- From: operationsengineer1
- Re: SQL Question - Almost, Not Quite...
- Prev by Date: Re: SQL Question - Almost, Not Quite...
- Next by Date: Re: SQL Question - S/B Good...
- Previous by thread: Re: SQL Question - Almost, Not Quite...
- Next by thread: Re: SQL Question - S/B Good...
- Indexes: