SQL删除重复数据

name.age.是重复的，sql:

Delete from TB where id not in ( 
select max(t1.id) from TB t1 group by t1.id, 
t1.name,t1.age)