--备份 SELECTintoT_PM_ORGRANGE_bak1110FROMT_PM_ORGRANGE --检查是否备份成功 selectcount(1)fromT_PM_ORGRANGE_bak1110 --查询是否有重复脏数据 SELECTFORGID,FUSERID,FTYPEFROMT_PM_ORGRANGEgroupbyFORGID,FUSERID,FTYPEhavingcount(1)>1 --删除脏数据 DELETEFROMT_PM_ORGRANGEWHEREfidnotin(SELECTmax(Fid)FROMT_PM_ORGRANGEgroupbyFORGID...