mysql记录去重

DELETE FROM ywgl_jiean202001 where id not in (select bid from (select min(id) as bid from ywgl_jiean202001 group by exam_num,app_num,tongji_month,jiean_type) as b )