表名称
code600300
delete from code600300 where id not in (select minid from (select min(id) as minid from code600300 group by date) b);
表名称
code600300
delete from code600300 where id not in (select minid from (select min(id) as minid from code600300 group by date) b);
转载于:https://www.cnblogs.com/curious2017/p/6322666.html