> A table was created like
>
> create table Test(ITEM varchar(20) not null primary key, VAL
> varchar(20));
>
> It is filled by records like
>
> (aaa_20111215, ...)
> (aaa_20111215, ...)
> (aaa_20111201, ...)
> ...
>
> My question is how to select the record having the latest date for ITEM?
>
> The answer for the above records is (aaa_20111215, ...).
>
> Please write a sql to do this.

Add an additional DATE column to the table, put an descending index on
that column and use MAX to query the record with the most recent date entry.


--
With regards,
Thomas Steinmaurer

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php