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