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;