select max(id),name,success from 表名 group by name
delete from 表名 where id not in (select max(id) from 表名 group by name)

说的不够具体，如果保留一个，那要保留哪个呢?