WITH tblTemp as ( SELECT ROW_NUMBER() Over(PARTITION BY Col1,Col2 ORDER BY Col1) As RowNumber,* FROM [table_name] ) DELETE FROM tblTemp where RowNumber >1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)