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 )

posted @ 2020-07-20 22:24  一天从晚上开始  阅读(175)  评论(0编辑  收藏  举报