you have to add the creation date as a column to the table...
and then you can run:
select top 1 * from tableName where (criteria=1) order by dateCreated desc