GoldMine SQL Query – Duplicate Records based on Company

Many clients have databases that have duplicate records. The SQL query below will return information based on the company name being duplicated in the database.

select company,contact,address1, address2, zip,phone1 from contact1 where company <>” and company in (select company from contact1 group by company having count(*) >1) order by company