Tag: remove duplicate rows from a table in SQL Server

• Remove duplicate rows from a table in SQL Server

  Hello Friends, I have tried to remove the duplicate rows from the table using row_number function. Here I am explaining the demo using the temp table. Steps: 1. Create Temp Table or Select your table Create Table #Main ( id int, item varchar(100) ) 2. Insert some records insert into #main values (119,1) insert into…

  Amit Patriwala

  May 12, 2011