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