Scott,
On Nov 12, 2004, at 10:00 AM, Scott Frankel wrote:
> color | date
> --------+------------
> red | 2004-01-19
> blue | 2004-05-24
> red | 2004-04-12
> blue | 2004-05-24
>
>
> How do I select the most recent entry for 'red'?
>
SELECT color, MAX(date)
FROM giventable
WHERE color = 'red' -- omit this line if you'd like to see the latest
date for each color
GROUP BY color;
OT hint: You might want to take a look at the list of PostgreSQL
Keywords in the documentation and avoid using them (such as date) to
help you avoid naming issues in the future.
Hope this helps.
Michael Glaesemann
grzm myrealbox com