[firebird-support] last record from a table

[Sergio H. Gonzalez]

(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!!


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