mysql查询练习

mysql删除重复记录，保存Id最小的一条

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