Duplicate Records

[MTSPEER]

Hi,

I imported an excel file into my table, and I'm trying to Set the primary key as the ID Number. But there is duplicate records. And there is a lot of records, so its hard to find. What is the query I can run to fix this? The field name is ID Number. the table is called Customer.



-Thanks

[Dal Jeanis]

If you already have the data in the table, you could run something like this, and it would provide a list of the duplicate ID Numbers.

SELECT [ID Number], COUNT(*) 
FROM [Customer]
GROUP BY [ID Number]
HAVING (COUNT(*) > 1);

[MTSPEER]

Thank you!