Re: Duplicate records

Sushama Belkhode wrote:
>
> Can anyone tell me how to weed out duplicate records from a large(> 1
> million records) table quickly and efficiently?
>
> Thanks in advance
>
> Sushama

Sushama,

There are any number of methods of removing duplicate records. If you checkout my web page
you will find a code fragment and description of one of the many methods.

Rgs Gary Piper

-- 

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Gary Piper ( gpiper_at_ozemail.com.au )
http://www.ozemail.com.au/~gpiper/
Phone  : 61-3-9827-4276
Fax    : 61-3-9827-4917
Mobile : 0419-352-584 ( International 61-419-352-584 )
----------------------------------------------------------------------