删除重复数据

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

        $sql = 'delete from tbTeachingV3Student where id not in
                (
                    select minid from
                     (select min(id) as minid from tbTeachingV3Student group by fdTeachingV3ID,fdStudentID
                     ) b
                 )';

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/huixuexidezhu/p/5956286.html