Hi !

Em 27/1/2012 17:47, Sergio H. Gonzalez escreveu:

> (Firebird 2.5)
>
> Hello! this is probably an old question, but didn't find nothing on the
> net...
>
> Here's a sample table: MyTable (has two fields) = ID: integer& MyDate: Date
>
> Is this the best (fastest) way to get the LAST inserted record from a table?
>
> select MyDate from MyTable where id = (select max(id) from MyTable)
>
> Thanks!!
>

I would go for:

select first 1 MyDate from MyTable order by ID desc

With a descending index on ID of course.

see you !