MSSQL: Delete rows with duplicated values in some field

— delete duplicates T1.ProductName
DELETE D
FROM
(
SELECT ProductName, ROW_NUMBER()OVER(ORDER BY ProductName) AS RowNum
FROM T1
) D
JOIN
(
SELECT ProductName, ROW_NUMBER()OVER(ORDER BY ProductName) AS RowNum
FROM T1
) E
ON D.ProductName = E.ProductName AND D.RowNum < E.RowNum;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: