How to remove duplicate row without primary column in SQL table?
Remove duplicate row without primary column in SQL Server
WITH CTE AS (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY [Name] ORDER BY [Name] ) AS RowNum FROM dbo.[User]
)
DELETE FROM CTE
WHERE RowNum > 1;
1