i think this would help u to retrieve the last record

select * from tablename where Id in ( select top 1 Id from...