sql语句去除重复数据

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 ='取消订单'