Removing Duplicates from a table using CTE

with emp_cte (rownum , empid , Name)
as
(
select row_number() over (order by  empid, Name, Salary) as row_num ,row_number() over (partition by  Name , Salary order by  empid, Name, Salary)  as rownum , empid , Name
from employee_data_new ed
)
delete from emp_cte  where row_num  in (
select row_num  from emp_cte where rownum <> 1);
;