Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Sureshkumar Ramakrishnan Deleting Duplicate Records RE: Deleting Duplicate Records

  • April 16, 2007 at 3:29 am

    #700640

    Or, if you use SQL Server 2005,

     

    DELETEt1

    FROM(

    SELECTROW_NUMBER() OVER (PARTITION BY Col1 ORDER BY Col2 DESC) AS RecID

    FROMTable1

    ) AS t1

    WHERERecID > 1

     

    N 56°04'39.16"
    E 12°55'05.25"