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
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 |