SQL 查询代理 ID=3365 同个主单号数量大于 1 的订单数据

SELECT * FROM orders WHERE agent_id = 3365 AND main_order_number IN ( SELECT main_order_number FROM orders WHERE agent_id = 3365 GROUP BY main_order_number HAVING COUNT(*) > 1 )