codice:
select t1.* from tabella as t1
inner join (
select id from tabella order by campo_timestamp desc) as t2
on t1.id = t2.id
group by date(t1.campo_timestamp)