On Thu, 8 Feb 2001, Linsen Limsico wrote:
Does anyone know how to find duplicates in a table and deleting them. I can't figure
out how to structure the query.
Linsen
Hello,
Being new to this I don't know the coding however I would look at making
another table and then use the UNIQUE command
Depending upon the function of the table, you might consider
designing your table such that duplicates aren't possible (e.g.
putting a UNIQUE index on a column or set of columns).
Other than that, try dumping your table, removing the rows you
don't want, and reloading the table.
-Tilghman
--