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]
