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?

Probably not the quickest or most efficient but you can always change the name of the table and create it again from a SELECT DISTINCT * FROM renamed_table. Then (the ultimate solution) alter the table and/or your apps so duplicate records are not entered in the first place.

-- 
Tomm Carr
---- ----
Hunting for a job is like hunting for an elephant.
If you're not *very* careful, you might find one!