Posted by Alexander Kuznetsov on 10/06/05 21:32

another way of removing duplicates is to
select distinct * into new table
drop old table
rename the new table

Could be much faster

• Next in forum: Re: Search Advice
• Prev in forum: Re: Import cell data from XLS into SQL table
• Thread view: Re: delete of mirrored rows

[Reply to this message]