SQL 删除重复数据 根据多个字段删除重复数据,保留ID最小的记录: DELETE A FROM Table A , (SELECT Para1,Para2 FROM Table GROUP BY Para1,Para2 HAVING COUNT(*) > 1 ) B WHERE A.Para1=B.Para1 AND a.Para2= b.Para2 AND A.ID NOT IN (SELECT MIN(ID) AS ID FROM Table GROUP BY Para1,Para2 HAVING COUNT(*) > 1)