select a.* from t as a right join (select pet_id, max(note_time) max_note_time from t group by pet_id) as b on b.pet_id=a.pet_id and b.max_note_time=a.note_time;