{eval=Array;=+count(Array);}
delete t1
From t1
where id Not in (select Max(a.id) from t1 as a where t1. id=a. id
group by a. name )
0