查出重复的数据---------oracle

select chcod, count(1) from a
group by chcod
having count(1) > 1

原文地址:https://www.cnblogs.com/weiryang/p/5778912.html