Or even more simply... 🙂

DELETE D FROM

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

FROM dbo.T1) D

where RowNum > 1

-- Two methods I really like (and plagiarized from people on here).

create table #ttemp

(cola int not null)

insert into #ttemp (cola) values (1)

insert into #ttemp (cola) values (1)

insert into #ttemp (cola)...

Here is a CTE based solution....

; WITH EmployeesCTE

AS

(

SELECT ROW_NUMBER() OVER( PARTITION BY EmpID, EmpName ORDER BY EmpID ) AS RowNumber,

...

This gives me syntax errors