Duplicate Rows

murad · Post by **murad** » Wed Aug 06, 2003 11:37 am

I have duplicate rows in my table. What would be the best way to remove them?

Post by **mark** » Wed Aug 06, 2003 12:03 pm

sql "delete".

If you want to just remove one and leave the other use tsql -l 1 "delete ..."

Post by **Kai** » Thu Aug 07, 2003 12:28 pm

If there are one or two columns that must never be duplicated across rows, especially a small type like an int, counter or short (<~100 bytes) varchar, you could create a unique index on the column to prevent duplicate insertions in the future.

murad · Post by **murad** » Thu Aug 07, 2003 12:38 pm

Thanks for the help