查询重复订单

查询重复订单
select openid from `#_order` where openid in (select openid from `#_order` group by openid having count(1) > 1) group by openid;