批量删除NAME为一样的数据

SQL
1 行
delete from table where id not in(select min(id) from table group by name);