CREATE TABLE new_name AS SELECT DISTINCT * FROM old_name;
DROP TABLE old_name;
ALTER TABLE new_name RENAME TO old_name;
On 2005-11-04 17:15, Peter Atkins wrote:
> All,
>
> I have a duplicate row problem and to make matters worse some tables don't have a PK or any unique identifier.
>
> Anyone have any thoughts on how to remove dups?