MSSQL 删除重复并只保留一条

时间:2021-10-15 18:32:50

重复值查找

select field1,field2 from table
group by field1,field2  having COUNT(*)>1

删除重复值,只保留ID最小的那条


delete table
where field1 in (select field1 from VersionProductRelation a
group by field1,field2 having COUNT(*)>1)

and field2 in (select field2 from VersionProductRelation a
group by field1,field2 having COUNT(*)>1)

and ID not in (
select MIN(ID) from table 
group by field1,field2 having COUNT(*)>1)