单表清除重复数据

delete  from 表名 a where 列名
         in
(
select t.列名 from  
(select
         列名 ,count(*) 
         from 表名
         where 列名 is not null 
         group by 列名
         having count(*) > 1) t
         
)