Remove duplicate sql (for example nop commerce specification attributes)

removeduplicate.sql

WITH duplicates AS (
	SELECT
	*,
	ROW_NUMBER() OVER (
	PARTITION BY SpecificationAttributeId, Name
	ORDER BY SpecificationAttributeId, Name
	) RN
	FROM
	[nopdb].[dbo].[SpecificationAttributeOption]
)
DELETE FROM duplicates WHERE RN > 1;
--SELECT * FROM duplicates WHERE RN = 1;