代码很简单,留着复制黏贴用
--删除重复列
delete from sn
where serialnumber in (select serialnumber from sn group by serialnumber having count(serialnumber) > 1)
and id not in (select min(id) from sn group by serialnumber having count(serialnumber)>1)
select * from sn
where serialnumber in (select serialnumber from sn group by serialnumber having count(serialnumber) > 1)