删除user表(含字段id和字段name)中重复的name字段,保留唯一的name字段,要求保留的name对应的id值最小 2015/11/16 14650 delete from user where id not in(select min(id) from user group by name);