Note: watch out for ending previous statement with SEMICOLON

Here's a working code sample

CREATE TABLE #Test

(

EmpID INT,

EmpName VARCHAR(50)

)

INSERT INTO #Test VALUES(1,'Daya')

INSERT INTO #Test VALUES(1,'Daya')

INSERT INTO #Test VALUES(1,'Daya')

SELECT * FROM #Test;

WITH Emp AS (SELECT ROW_NUMBER ( ) OVER ( PARTITION BY EmpID, EmpName ORDER BY EmpID ) AS RNUM FROM #Test )

DELETE FROM Emp WHERE RNUM > 1

--SELECT FROM Emp WHERE RNUM > 1

SELECT * FROM #Test

DROP TABLE #Test