delete from 表名where id in(select id from(select a.*,row_number() over (partition by MATNR order by id) as seq from 表名 a ) where seq>1)
partition by分组
order by 排序
delete from 表名where id in(select id from(select a.*,row_number() over (partition by MATNR order by id) as seq from 表名 a ) where seq>1)
partition by分组
order by 排序