WITH CTE AS( SELECT referenceNo, RN = ROW_NUMBER()OVER(PARTITION BY referenceNo ORDER BY referenceno ) FROM dbo.[Order] ) DELETE FROM CTE WHERE RN > 1
Senior .NET Developer & Tech Partner for Scalable Software Solutions
by kriztine
WITH CTE AS( SELECT referenceNo, RN = ROW_NUMBER()OVER(PARTITION BY referenceNo ORDER BY referenceno ) FROM dbo.[Order] ) DELETE FROM CTE WHERE RN > 1