delete from tb_abnormal_warning where id in (select a.id from (select id,count(1),car_id from tb_abnormal_warning group by car_id having count(1)>1)a)
删除重复数据,保留一条(只重复了2条的情况)
最新推荐文章于 2024-07-07 12:29:28 发布
delete from tb_abnormal_warning where id in (select a.id from (select id,count(1),car_id from tb_abnormal_warning group by car_id having count(1)>1)a)