删除重复数据

delete from 表  where id in (select id from (select  max(id) as id,count(列) as count from 表group by 列 having count >1 order by count desc) as tab )