Steve Meynell <steve@candata.com> writes:
> select * from basket where max(date) and fruit='Apples';
> I know this doesn't work but I need something like it.
Perhaps
select * from basket where fruit='Apples' order by date desc limit 1;
The limit clause is not standard SQL, but it's a pretty easy answer
if portability doesn't bother you...
regards, tom lane