mysql 删除某字段重复数据并保留id最小的数据

delete from table where
order_no in (select orderno from (select order_no as orderno from table group by order_no having count(order_no) > 1) a)
and id not in (select pid from (select min(id) as pid from table group by order_no having count(order_no) > 1 ) b)