使用row_number。假定存在另一列或多列有助于识别要保留的列。
;with r as ( select SourceGradeId, row_number() over (partition by SourceGradeId order by <other col>) rn from A ) delete r where rn>1
使用row_number。假定存在另一列或多列有助于识别要保留的列。
;with r as ( select SourceGradeId, row_number() over (partition by SourceGradeId order by <other col>) rn from A ) delete r where rn>1
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
