--创建临时表tmp,保存id最小的值 create table tmp as select min(id) as col1 from student group by name; --删除不在临时表中的数据(重复数据) delete from student where id not in (select col1 from tmp); --删除临时表 drop table tmp;