Re: [SQL] Help Retrieving Latest Record

[Tom Lane]

Steve Meynell <[EMAIL PROTECTED]> 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