Seemingly simple SQL query

SELECT *
  FROM myTable t
 WHERE myTimestamp = (SELECT MAX(myTimestamp) FROM myTable WHERE myIDCol = t.myIDCol)

That ought to do it.