Prorsal

摘要： --删除重复数据（多字段）with m AS ( select *, row_number() over(PARTITION BY column1,column2,column3,column4,column5 ORDER by ValueAddedTaxGUID) rn FROM tableName ) delete m where rn > 1 阅读全文