How 'bout these:
fgdata=# select * from fruit order by dt desc limit 1;
number | fruit | dt
+-+
20 | Oranges | 2000-06-07 00:00:00-05
(1 row)
fgdata=# select * from fruit where fruit='Apples' order by dt desc limit
1;
number |
Get an SQL book.
select * from basket
where date=(select max(date) where fruit='Apples)
and fruit='Apples';
On Thu, 15 Feb 2001, Steve Meynell wrote:
> Ok what I am trying to do is select out of the database the latest
> record meeting a certain criteria.
>
> Example:
>
> Number
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
