can be re-written like this :

WITH CTE AS

(

SELECT Emp_Name, Company, Join_Date, Resigned_Date, ROW_NUMBER() OVER (order BY Emp_Name, Company, Join_Date, Resigned_Date) AS ROWNUM

from #Emp_Details

)

DELETE FROM CTE

WHERE ROWNUM NOT IN (SELECT MAX(ROWNUM) FROM CTE

GROUP BY Emp_Name, Company, Join_Date, Resigned_Date)