There's more than one way to delete duplicate rows. However, you will need to write a SQL query to do it. Since you didn't post your table definition, I can't give you an exact solution, but here is a sample of what you might do:declare @t table (a int, b int, c int, d int, e int)insert into @t (a, b, c, d, e) values (1, 2, 3, 4, 5), (3, 4, 2, 3, 4), (1, 2, 3, 4, 5)select a,b,c,d,e, rn = row_number() over ( partition by a,b,c,d,e order by a,b,c,d,e)from @t;with cte as ( select a,b,c,d,e, rn = row_number() over ( partition by a,b,c,d,e order by a,b,c,d,e) from @t)delete from cte where rn > 1;
Auto Delete duplicate value from table
Posted - 2014-11-06 : 04:46:02
