TO Eliminate Duplicate Data From Duplicate Table????????

To Find
WITH Temporary_table (Empid,Sub_id, Count_Duplicate)
AS
(
SELECT Empid,Sub_id,ROW_NUMBER() OVER(PARTITION BY Empid,Sub_id ORDER BY Empid) AS Count_Duplicate FROM Emp_table
)

To Eliminate
DELETE FROM Temporary_table WHERE Count_Duplicate > 1