查询出表中反复纪录

查询出表中重复纪录
--查询出表中重复纪录
select rxn_trans_ref from rxn_txn_pr group by rxn_trans_ref having count(*)>1


select * from rxn_txn_pr a, rxn_txn_pr b where a.rxn_trans_ref=b.rxn_trans_ref and a.rowid <> b.rowid;