1. 查询重复订单号数量 使用group 加 having count(*) > 1 select 字段名,count(*) from table group by 字段名 having count(*) > 1