Re: delete duplicate records [message #35628] |
Tue, 02 October 2001 07:54 |
John D. Elliott
Messages: 3 Registered: October 2001
|
Junior Member |
|
|
The quick way to do this is to create a temporary table with the information in it and then blow away the original table then recreate it.
create table temp1 as select distinct * from originalTable;
That creates the temp table with unique rows.
Now get rid of the original table:
drop table orginialTable;
and re-create it:
create table originalTable as select * from temp1;
That should do it!
Enjoy!
John E.
----------------------------------------------------------------------
|
|
|