Remove duplicates in SQL Server when tables have no primary key
I have table called CricketerDetails, and the table has no primary or unique key.
Below i have mentioned how to remove duplicate items with query.
1. Procedure to remove the Duplicate rows with query is
WITH tempTable as
SELECT ROW_NUMBER() Over(PARTITION BY FirstName,LastName,HighestScore ORDER BY FirstName) As RowNumber,* FROM CricketerDetails
DELETE FROM tempTable where RowNumber >1
SELECT * FROM CricketerDetails order by FirstName asc