删除user表(含字段id和字段name)中重复的name字段,保留唯一的name字段,要求保留的name对应的id值最小

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

delete from user where id not in(select min(id) from user group by name);