清除SQL数据库里的重复记录

delete a from es_iddel a where exists(select * from es_idused where stdId=a.stdId and theId=a.theId) 用这个SQL可以清除重复记录。 select * from es_idUsed where rcId not in (select rcId from es_repcase) 里面的theid是废号，如果不需要可以删掉