这是所有表都应具有主键的众多原因之一（不一定是ID号或IDENTITY，而是一个或多个可唯一标识行并且在数据库中具有其唯一性的列的组合）。
您最好的选择是这样的：
SELECt field1, field2, field3, count(*) INTO temp_table1FROM table1GROUP BY field1, field2, field3 having count(*) > 1DELETe T1FROM table1 T1INNER JOIN (SELECt field1, field2, field3 FROM table1 GROUP BY field1, field2, field3 having count(*) > 1) SQ ON SQ.field1 = T1.field1 AND SQ.field2 = T1.field2 AND SQ.field3 = T1.field3INSERT INTO table1 (field1, field2, field3)SELECt field1, field2, field3FROM temp_table1DROP TABLE temp_table1
