>< SNIP >
>Nadya,
>
>I think you should write FAQ 'How to delete duplicate records'. Include all four ideas: Message #
565099, Message #
565029, Message #
565097 and Message #
565101 with explanation of there Pros and Cons.
Ok, I'll do. BTW, another method would be:
select distinct * from originaltable into myNewTable
delete originalTable
rename file NewTable to OriginalTable, if we're talking about free tables
or zap original and append.
However, I believe, the algorithm, I finally described with your corrections is the optimum here.
If it's not broken, fix it until it is.
My Blog