mysql操作重复数据

这两天为公司做的网络爬虫获取了一堆数据，存在不少重复的，需要在数据库中将重复的数据清除，学习了一下sql相关语句

1、先做备份咯：

CREATE TABLE salesback1 LIKE salesback;   INSERT INTO salesback1 SELECT * FROM salesback;

2、查询一下有多少重复语句：

SELECT * FROM salesback1 WHERE  company IN (SELECT company FROM  salesback1  GROUP BY company HAVING  count(company) > 1

3、删除重复数据：

delete from sales where id in (select id from (select id from sales where company in (select company from sales group by company having count(company)>1)  and id not in(select min(id) from sales group by company having count(company)>1) )a)

4、查询条数：

select count(*) from salesback1