Xóa dữ liệu trùng trong sqlserver

Question

;With Numbered
as
(
                Select Row_number() over (partition by name order by id, name) RowId, * from #DuplicateNames
)
Delete from Numbered where RowId <> 1