oracle删掉重复数据的语法

--查询重复数据--
SELECT XYH,COUNT(*) FROM BGJL GROUP BY XYH having(count(*)>1) 

--删掉重复数据--
DELETE from BGJL WHERE (XYH) IN ( SELECT XYH FROM BGJL GROUP BY XYH HAVING COUNT(XYH) > 1) AND ROWID NOT IN (SELECT MIN(ROWID) FROM BGJL GROUP BY XYH HAVING COUNT(*) > 1);