删除重复数据（多字段）

--删除重复数据（多字段）
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