Delete Duplicate Records Microsoft SQL Server Example

delete from a from (select Emp_Name, Company, Join_Date, Resigned_Date        ,ROW_NUMBER() over (partition by Emp_Name, Company, Join_Date                           ,Resigned_Date                            order by Emp_Name, Company, Join_Date                           ,Resigned_Date) RowNumber from Emp_Details) a where a.RowNumber > 1   This method is much simpler and more efficient than using temp tables and group by clauses.