oracle基于单个列重复行

SELECt  a.*FROM    TableName a        INNER JOIN        ( SELECt  EmpID FROM    TableName GROUP   BY EmpID HAVINg  COUNT(*) > 1        ) b ON a.EmpID = b.EmpID

• SQLFiddle演示

尽管我更喜欢上面的 方法， 但是 另一种方法是使用

IN

SELECt  a.*FROM    TableName aWHERe   EmpId IN        ( SELECt  EmpId FROM    TableName GROUP   BY EmpId HAVINg  COUNT(*) > 1        )

• SQLFiddle演示