delete from table_name where duplicate_field in
(select * from (select duplicate_field from table_name
group by duplicate_field having count(duplicate_field) > 1)
group by duplicate_field having count(duplicate_field)>1) as b);
------table_name是表名,duplicate_field是用来判断重复的字段,
可根据duplicate_field来判断数据是否重复
sql删除重复数据,只保留一条
最新推荐文章于 2024-07-11 10:27:20 发布