sql01

• 修改自己表里面重复的数据，只保留一条

create table temp as select id as c
from machine_score where model in ( select model
from machine_score GROUP BY model HAVING count(*) > 1 )
and id not in (select min(id) from machine_score GROUP BY model)