MySQL中在原表中做数据去重(按日期去重,保留id最小的记录)

表名称

code600300

 

 

delete from code600300 where id not in (select minid from (select min(id) as minid from code600300 group by date) b);

posted @   L''  阅读(3442)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示