Removal of dup SSN# from a report. Duplicate records with same

M

Meltiff2003

I need to remove duplicate records with same SS# to create report without
duplication. I would like Primary Key to be the SS#.
 
J

JaRa

Try this sql statement

SELECT SS#, Count(SS#) FROM Table GROUP BY SS# WHERE Count(SS#)>1

- Raoul
 
Top