MySql 单表 join 删除

浏览量: 2

#从学生表中删除姓名重复的学生记录, 仅保留重复记录中id最大的一条
delete a
from t_student as a
 join (select name, max(id) as maxid
         from t_student 
       group by name
       having count(*) > 1
      ) as b
	on a.name = b.name and a.id < b.maxid

#从学生表中删除姓名重复的学生记录, 仅保留重复记录中id最大的一条

delete a

from t_student as a

join (select name, max(id) as maxid

from t_student

group by name

having count(*) > 1

) as b

on a.name = b.name and a.id < b.maxid

IT农民工

又一码农的一亩三分地

MySql 单表 join 删除

发表回复取消回复

发表回复 取消回复

发表回复取消回复