删除 重复行数据

select * from (select *, ROW_NUMBER() OVER(partition by [FLID],[ZBM],[MC] Order by [FLID],[ZBM],[MC] ) AS RowNumber
from [MaterialClassFLMX])a where a.RowNumber>1

delete a from (select *, ROW_NUMBER() OVER(partition by [FLID],[ZBM],[MC] Order by [FLID],[ZBM],[MC] ) AS RowNumber
from [MaterialClassFLMX])a where a.RowNumber>1

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/xiaoruilin/p/7082144.html