• Here is a CTE based solution....

    ; WITH EmployeesCTE

    AS

    (

    SELECT ROW_NUMBER() OVER( PARTITION BY EmpID, EmpName ORDER BY EmpID ) AS RowNumber,

    EmpID, EmpName

    FROM Employees

    )

    DELETE

    FROM EmployeesCTE

    WHERE RowNumber != 1

    --Ramesh

    This is elegant...