Oracle sql 判重

单字段判重

select * 
from key_rkjcb
where zjhm_695 in (select zjhm_695 from key_rkjcb group by zjhm_695 having count(zjhm_695) >1)
and rowid not in (select min(rowid) from key_rkjcb group by zjhm_695 having count(zjhm_695 )>1);

多字段判重

SELECT * FROM KEY_SOURCEFW_DATA T1 WHERE (T1.JLX, T1.MLPH, T1.MLXZ) IN 
(SELECT JLX, MLPH, MLXZ FROM KEY_SOURCEFW_DATA GROUP BY JLX, MLPH, MLXZ HAVING COUNT(*) > 1);