Subject Re[2]: [ib-support] Select Latest Row
Author Alexander Tabakov
>If you are using Firebird:

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

>That's the best you can do if creation_date is a dialect 3 DATE type. If
>it is timestamp, you will be OK.Yes

Yes, I use timestamp

Best regards,
Alexander mailto:saho@...