select creation_date, value
from aTable a
where creation_date = (select max(creation_date) from aTable b
where a.value = b.value)

(Untested)


In article <91307712718.20030322134859@...>, Alexander Tabakov
wrote:

> Well it must be running on both FireBird and Interbase 6.01.
> Any ideas on using max() function with creation_date?
>
> >select first 1 creation_date, value
> >from aTable
> >order by creation_date desc
>

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase - Available Shortly