SQL 去掉两个表中重复的数据

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;