删除重复行数据

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

相关阅读:
头文件<stdarg.h>
头文件<signal.h>
头文件<setjmp.h>
头文件<math.h>
头文件<locale.h>
头文件<limits.h>
头文件<ctype.h>
头文件<assert.h>
PHP error_reporting
八大排序算法

原文地址：https://www.cnblogs.com/xiaoruilin/p/7082144.html

删除 重复行数据

删除重复行数据