How do you remove duplicate rows from a database table?

United States
December 16, 2006 5:03pm CST
I'm waiting...this is something I'd like to really know as soon as possible so fill me in folks!!!
2 responses
• Singapore
21 Jan 07
to avoid it to happen you can set a value/ a set of values to be unique. But I'm not sure whether the database will automatically delete the repeating row if you set the unique value/s after you already have the duplicated rows
• Philippines
16 Dec 06
which database are u using?