delete from tab_order where id not in (
select t.max_id from
(select max(id) as max_id from tab_order group by order_no) as t
);
上面是数据库语句,仅做参考,记得操作前一定要先备份,否则出现问题,等shi…
本语句是以 订单号:order_no为查询条件,删除订单号重读的数据,保留最新的一条,可做参考修改语句,别copy,直接copy用不了的。