Subject Re: [ib-support] Select Latest Row
Author Nick Upson
select creation_date, value
from aTable a
where creation_date = (select max(creation_date) from aTable b
where a.value = b.value)


In article <91307712718.20030322134859@...>, Alexander Tabakov
> 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

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