SELECT * from tb_weixin_order WHERE out_trade_no IN(
select out_trade_no from tb_weixin_order GROUP BY out_trade_no HAVING COUNT(out_trade_no)>1 #条件是数量大于1的重复数据
)
DELETE FROM tb_weixin_order WHERE out_trade_no
IN (SELECT out_trade_no FROM (SELECT out_trade_no FROM tb_weixin_order GROUP BY out_trade_no HAVING COUNT(out_trade_no)>1) e)