>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.

This command will collect duplicated field1 and filed2 values:
Select field1,field2 ;
From Table1 ;
Group By field1,field2 ;
Having count(*)>1