Hi ,

CREATE TABLE #prod(Product_Code varchar(10),Product_Name varchar(100))

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('123','Product_1')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('234','Product_2')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('345','Product_3')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('345','Product_3')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('456','Product_4')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('567','Product_5')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('678','Product_6')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('789','Product_7')

SELECT * FROM #prod;

With Dups as

(

select *, row_number() over (partition by Product_Code order by Product_Code) as RowNum from #prod

)

Delete from Dups where RowNum > 1;

In RowNum r and n was written in lower case for the delete command i changed it

Chandru.V