显示、拷贝重复行的sql
显示重复行
select keyword, count(*)
FROM topnew
GROUP BY keyword
HAVING count(*) > 1
新建表，拷贝非重复行，重复行一个不留……
create table topnew as
select id,query,keyword,category,choose,date from top500
group by keyword
having count(*)>0;
create table list as
select id,title,body,url from nc_datas
group by id;
