Monday, June 29, 2015

GoldMine : Querying Duplicate Records

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.

1 comment:

PLC training in chennai said...

WIZTECH Automation, Anna Nagar, Chennai, has earned reputation offering the best automation training in Chennai in the field of industrial automation. Flexible timings, hands-on-experience, 100% practical. The candidates are given enhanced job oriented practical training in all major brands of PLCs (AB, Keyence, ABB, GE-FANUC, OMRON, DELTA, SIEMENS, MITSUBISHI, SCHNEIDER, and MESSUNG)

PLC training in chennai
Automation training in chennai
Best plc training in chennai
PLC SCADA training in chennai
Process automation training in chennai
Final year eee projects in chennai
VLSI training in chennai