I have a database that has one table that has 30 fields. The first field is an integer that is a Primary Key and can not contain duplicates. The second column can contain duplicates only because it can contain ‘NONE’. Same with the third field it can contain duplicates and again only it can contain ‘NONE’. My database has about 130,000 records in the Main_Table.
The problem is that there are duplicates in the second and third fields that need be removed. ‘NONE’ is not to be considered a duplicate.
I know that I will have to do at least two statements or queries. The first one, deleting the duplicates in the second field, and the second query, to delete the duplicates in the third field.