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