删除数据库中多余的重复记录(在mysql的数据库上测试过，成功删除)

delete a from student a,(select xm,xh,max(UUID) UUID,count(*) mid from student group by xm,xh having count(*)>1) b 
where a.xm=b.xm and a.UUID!=b.UUID