I need a SQL Server T-SQL query to delete rows with duplicate values in selected columns but don’t delete all the duplicates; make those duplicates become unique rows.
Can someone please help me?
I used DISTINCT
, FILTER
, HAVING
, etc but it didn't work out.