--删除OrderDetails表中materialscode字段重复的行,只保留ID最小的一行数据
delete from OrderDetails
where materialscode in (select materialscode from OrderDetails group by materialscode having COUNT(*)>1) and
ID not in (select MIN(ID) from OrderDetails group by materialscode having COUNT(*)>1)
--删除OrderDetails表中orderdate,ordernumber,materialscode字段重复的行,只保留ID最大的一行数据
delete from OrderDetails
where materialscode in (select materialscode from OrderDetails group by orderdate,ordernumber,materialscode having count(*) > 1)
and ID not in (select max(ID) from OrderDetails group by orderdate,ordernumber,materialscode having count(*)>1)