Steve Meynell <steve(at)candata(dot)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