Thursday, June 30, 2016

GoldMine : Simple Duplicate Record Queries

Here is an easy way to determine how many potential Duplicate Records you might have in your database.

Open the SQL Query window by selecting Tools | SQL Query from the top level menu.

If you want to see duplicates based on, for example, Contact and Phone1, paste in the following Query text and run it:

select count(*), contact, phone1
from contact1
group by contact, phone1
having count(*) > 1

If you'd like to include the Company field in the query as a duplicate check, use this:

select count(*), contact, phone1, company
from contact1
group by contact, phone1, company
having count(*) > 1

Try it! You might be surprised at how many duplicates there might be in your database.

2 comments:

James Lackey said...

I am thankful to stumble on this blog post extremely ready to lend a hand for me, as it contains lot of facts. I always choose to read the quality blog content and this thing I found in you blog post. Gratitude for sharing. RTC bus advertising in Coimbatore ad lights examples and forces enthusiasm for the things and organizations they progress as they make an undeniable determination with respect to where the excursion begins and terminations. Advancing on transports makes and fortifies brand pictures as they acknowledge the way things seem to be.

阿童木 said...

Patek Philippe and Rolex consistently appear to apperception if top dollar watches appear up in conversation. Examples that were beat alone on break and in excellent or abutting to excellent condition, of course, accompany the a lot of money. Watches with provenance--examples endemic by celebrities or rolex replica fabricated especially for acclaimed individuals--always accept added amount if replica watches uk they appear with adapted documentation.With that said, in her book Vintage Wristwatches (Krause Publications), above Antiques Roadshow adjudicator Reyne Haynes (who now goes by the name Reyne Hirsch) credibility out, "Much like affairs a rolex replica watches monogrammed section of argent collectors generally don't wish anyone else's name, business affiliation, marriage anniversary.