摘要:--删除某几列相同的,重复数据deletefromProcess.SSC_HqItemConfigWHEREIDNOTIN(selectmin(ID)fromProcess.SSC_HqItemConfiggroupbyCompanyCode,FlowCode,ActivityType,BusinessCodehavingcount(CompanyCode)>1)ANDexists(--匹配原来某些列 select * from ( SELECTCompanyCode,FlowCode,ActivityType,BusinessCodeFROMProcess.SSC_HqItemConf
阅读全文