DELETE Duplicate, SQL, Mark Duplicate

WITH CTE AS
(
SELECT MyStatus,ROW_NUMBER() OVER
(PARTITION BY [EmployeeID]
Order BY [EmployeeID] )
AS RowNumber,
[EmployeeID]
FROM [dbo].MYTABLE tbl )
--DELETE FROM CTE Where RowNumber > 1
--SELECT * FROM CTE Where RowNumber > 1
update CTE set eligstatus='DP'
where RowNumber > 1
GO