SQL代码10亿行数据高效字段删除重复项

delete from kk where  Id  NOT IN (Select MIN(Id)  From kk Group By Tel Having Count(*)>1  --取重复里的最小的RowId记录 UNION Select MIN(Id)  From kk Group By Tel Having Count(*)=1)