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