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)
SQL代码10亿行数据高效字段删除重复项
最新推荐文章于 2022-05-19 00:57:05 发布
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)