delete OrderListfrom OrderList as aaleft join ( select min(id) as id from OrderList group by order_sn ) as bbon aa.id = bb.idwhere (Owner_id = 233617593)AND bb.id is null