删除数据库某字段重复数据

字段：partDrawingNo   表名：Sheet1$

select distinct partDrawingNo from Sheet1$

DELETE FROM Sheet1$ WHERE 
(id IN (SELECT a.id FROM Sheet1$ a LEFT OUTER JOIN (SELECT partDrawingNo FROM Sheet1$  GROUP BY partDrawingNo HAVING (COUNT(*) > 1)) AS b
ON a.partDrawingNo= b.partDrawingNo ))
AND
(id NOT IN(SELECT min(id) FROM Sheet1$ GROUP BY partDrawingNo HAVING (COUNT(*) > 1)))