MySql 去除重复数据

delete FROM `customer` WHERE `name` in 
(SELECT a.name from( select name FROM `customer` 
GROUP BY `name` 
HAVING COUNT(1) >1)a
) and id not in 
(SELECT b.id FROM(
select max(id) as id from customer group by name having count(1)>1
)b)

max() 保留大的

min() 保留小的