Home Forums Article Discussions Article Discussions by Author Discuss content posted by bdba Removing Duplicates RE: Removing Duplicates
rcassis-1001343
Valued Member
Points: 56
More actions
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