delete t from t a where id in
(select id from t as b where a.name = b.name and a.age = b.age and a.id<b.id)
(select id from t as b where a.name = b.name and a.age = b.age and a.id<b.id)
调试欢乐多
delete from t where id not in
(select min(id) from t group by name,age)