Finding duplicate values in a SQL table

Select and Delete Duplicate Records 

With EmployeeCTE As
(
Select *,Row_Number() over(Partition BY ID Order By ID) as Rownumber from Employees
)
Delete from EmployeeCTE where RowNumber>1