At 23:30 -0600 2/14/03, Lewis Watson wrote:
I need to delete duplicate rows. Each row that is in the table has an
exact duplicate of itself. There are four columns. No one column could be
defined as a primary key; however, two columns together could. What's
going to be the best way to do this?
Tha
Make a temporary table, SELECT DISTINCT the rows from the old table to the
new table, rename the old table TABLE_OLD, rename the temporary table to the
original table name.
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
-
