how is generated the id :) if it's a generator you can call this
generator to get the latest ID :)
fast as hell it's will be :)

On 1/27/2012 11:47 PM, Sergio H. Gonzalez wrote:
>
> (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]
>
>


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