Home Forums Article Discussions Article Discussions by Author Discuss content posted by bdba Removing Duplicates RE: Removing Duplicates

  • January 29, 2010 at 4:15 pm

    #1111064

    Or even more simply... 🙂

    DELETE D FROM

    (SELECT ProductName, ROW_NUMBER()OVER(ORDER BY ProductName) AS RowNum

    FROM dbo.T1) D

    where RowNum > 1