| 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: | Whole Thread | Raw Message | 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 |