oracle数据重复查询语句

select a.ordercode,count(*) from tb_order_yhd a group by a.ordercode having count(*)>1;

转载于:https://www.cnblogs.com/xuwj/p/3200551.html