oracle数据重复查询语句

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