Home Forums SQL Server 2005 T-SQL (SS2K5) delete duplicates RE: delete duplicates

  • February 9, 2009 at 7:14 am

    #940463

    Here is a CTE based solution....

    ; WITH EmployeesCTE

    AS

    (

    SELECTROW_NUMBER() OVER( PARTITION BY EmpID, EmpName ORDER BY EmpID ) AS RowNumber,

    EmpID, EmpName

    FROMEmployees

    )

    DELETE

    FROMEmployeesCTE

    WHERERowNumber != 1

    --Ramesh