开窗可以求

select * from temp where CONCAT(date,name) in (select CONCAT(MAX(date),name) res from temp a GROUP BY `name`);

用group by和MAX函数