查找表中重复两次以上的订单号

select order_id from table_name   group by order_id having count(1)>1

select distinct  pr.order_id  from table_name    pr where exists
(select 1  from table_name    prt where  prt.id !=pr.id  and pr.order_id =prt.order_id )


select distinct  pr.order_id  from table_name pr, table_name pr1 where pr.id !=pr1.id and pr.order_id =pr1.order_id