• The query will be composed this way:-

    WITH TempUsers (FirstName,LastName, duplicateRecordCount)

    AS

    (

    SELECT FirstName,LastName,

    ROW_NUMBER()OVER(PARTITIONBY FirstName, LastName ORDERBY FirstName) AS duplicateRecordCount

    FROM dbo.Users

    )

    DELETE

    FROM TempUsers

    WHERE duplicateRecordCount > 1

    GO

    Instead of TempUsers you can give any name. Because this is used only for Temporary purpose.

    Cheers,
    Bijayani
    Proud to be a part of Team Mindfire.

    Mindfire[/url]: India's Only Company to be both Apple Premier & Microsoft Gold certified.