ORACLE 查询重复记录

oracle 查询出 记录数大于2的记录

SELECT A.ROWID FROM USERCOMPANYINFO_BAK A,(SELECT MAX(A.ROWID) RROWID,COMPANY FROM USERCOMPANYINFO_BAK A GROUP BY A.COMPANY HAVING COUNT(*) > 2) B 
     WHERE A.COMPANY = B.COMPANY AND A.ROWID <> B.RROWID