sql获取具有最大日期和相对id记录的行

I try to make a simple query, spent on it a tone of hours and get nothing....I try to make a simple query, spent on it a ton