select * from T_Test A where date=(select max(date) from T_Test B where A.[Name]=B.[Name]) 原表记录 执行后结果