>>What is the best method to identify duplicate records in a table?
>>In this case there is approx 1.5 million records and i need to look at
>>each field.
>>
>>your help will be appreciated.
>
>You could do a select with a count then group by every field in the table. Anything the count is higher than 1 is a duplicate record.

Ed's got the right idea, you want to only keep the records with the count greater than one, use the "Having" clause.