select s.c_package_name,s.c_category_code,s.count1 from (select *,count(c_package_name) as count1 from `tb_app_top` group by c_package_name) s where s.count1>1;
select s.c_package_name,s.c_category_code,s.count1 from (select *,count(c_package_name) as count1 from `tb_app_top` group by c_package_name) s where s.count1=2;
#把重复的数据插入到sheet1中
insert into sheet1 select s.c_package_name,s.c_category_code from (select *,count(c_package_name) as count1 from `tb_app_top` group by c_package_name) s where s.count1=2;
#删除刚才插入的数据
DELETE FROM `tb_app_top` WHERE c_package_name in (select t.c_package_name from sheet1 t);
#把sheet1中数据插回来
insert into tb_app_top select * from sheet1;
select count(*) from tb_app_top;
SQL 去掉两个表中重复的数据
最新推荐文章于 2024-07-27 19:11:07 发布