请教一个数据库的问题，哪位大神帮忙回复下！谢谢！

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;