Select t1.*
from Table  t1
where t1.Datestamp = (Select max(t2.Datestamp) from Table t2 where t2.id = t1.id)