Something like this ?

WITH myCTE

AS (

SELECT row_number() over (partition by EmployeeID, Firstname,Salary

ORDER BY EmployeeID, FirstName, Salart ) as Colm1,*

from Employee_salary

)

DELETE From myCTE where Colm1> 1