Help retrieving lastest record

From: Steve Meynell <steve(at)candata(dot)com>
To: Postgresql Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Help retrieving lastest record
Date: 2001-02-15 21:04:50
Message-ID: 3A8C4471.CFDF9937@candata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ok what I am trying to do is select out of the database the latest
record meeting a certain criteria.

Example:

Number | Fruit | Date
15 Apples July 20, 1999
20 Oranges June 7, 2000
13 Pears Jan 31, 2000
17 Apples April 10, 1999
Now what I need to do is select the oranges out because the date is the
latest one, something like:

select * from basket where max(date);
This would yield me:
20 Oranges June 7, 2000

I know this doesn't work but I need something like it.
or something like

select * from basket where max(date) and fruit='Apples';
This would yield me:
15 Apples July 20, 1999

Thank you in advance,

--
Steve Meynell
Candata Systems

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Volker Paul 2001-02-16 08:24:09 Re: C/C++ interface
Previous Message Peter Eisentraut 2001-02-15 17:48:56 Re: [ADMIN] TPCH questions