select in_ordr_no,count(*) from t_pay_jnl group by in_ordr_no having count(*) > 1
按照字段in_ordr_no查询重复的列,统计数量
oracle查询字段重复数据
原文:https://www.cnblogs.com/yuanchaoyong/p/11649600.html