根据单个字段查询重复
select shop_order_id,count(shop_order_id) from ec_oms_order group by shop_order_id having count(shop_order_id) > 1
根据多个字段查询重复
select shop_order_id,shop_code,count(1) from ec_oms_order group by shop_order_id,shop_code having count(1) > 1