删除表中的重复记录
第一步找出重复记录
SELECT coachId,releaseDate,count(reId) FROM tb_release
GROUP BY releaseDate,coachId HAVING COUNT(reId) > 1;
第二步删除重复记录
DELETE FROM tb_release
where reId in(SELECT reId from
(SELECT reId FROM tb_release lbcr GROUP BY lbcr.coachId,lbcr.releaseDate HAVING count(lbcr.releaseDate)>1)
reId)