Subject Re: [ib-support] Select Latest Row
Author Helen Borrie
At 01:26 PM 22/03/2003 +0200, you wrote:
>I have a table with two fields "creation_date" and "value".
>There may be multiple couples (creation_date,value).
>How can I select the latest one?

If you are using Firebird:

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.