I want to delete duplicate records from this sql table (Contacts) if :
Cust#, First and Last Name are the same and the Contact_ID <> Main_Contact_ID
* upper/lower case does not matter.
* do not want to delete the duplicate that has the same Contact_ID and Main_Contact_ID
* keep all non-duplicate records
* last record in my .png should be deleted
If none of the duplicate records Contact_ID's match the Main_Contact_ID then I need to keep 1 (any one) of those duplicate records.