Duplicate record remove from table

Duplicate record remove from table

WITH DuplicateRecords AS

(

SELECT *,row_number() OVER(PARTITION BY FirstName,Department ORDER BY

FirstName)

AS RowNumber FROM dbo.Employees

)

DELETE FROM DuplicateRecords WHERE RowNumber>1