1、查找重复记录
select orderid from 表 where operatedesc ='取消订单' group by orderid having count
(orderid) > 1
2、删除
select * from 表
where orderid in (select orderid from 表 where operatedesc ='取消订单' group by orderid having count
(orderid) > 1)
and id not in (select min(id) from 表 where operatedesc ='取消订单' group by orderid having count(orderid
)>1) and operatedesc ='取消订单'