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 )
