Hi Julian,
You are right we cannot get the last record inserted till we keep a column to store the value.I think the original question was just to retrive the top 100 records in the table without any mention of whether it was last inserted or first.Do correct me if i am wrong.
take care,
Nishant.