rownumber 排序 通过delete 直接删除重复数据

delete cnei45 from(
Select Row_Number() Over(Partition by cost Order By cost asc ) As RowNumber ,
* from cnei45 ) cnei45
where cnei45.RowNumber >1