Subject last record from a table
Author Sergio H. Gonzalez
(Firebird 2.5)

Hello! this is probably an old question, but didn't find nothing on the

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)


[Non-text portions of this message have been removed]