Mysql 去重

delete from new_customers_visit_quchong
where id not in
(

select A.id
from
(select min(`id`) as id
from new_customers_visit_quchong
GROUP BY `客户电话`) A
)