Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to find duplicates
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00358922
Message ID:
00358930
Vues:
19
Hi Larry,

This is a quick and dirty sql statement that should get you going:

SELECT DISTINCTROW [Mailing List].FirstName, [Mailing List].LastName, Count([Mailing List].LastName) AS CountOfLastName
FROM [Mailing List]
GROUP BY [Mailing List].FirstName, [Mailing List].LastName
HAVING (((Count([Mailing List].LastName))>1))
ORDER BY Count([Mailing List].LastName) DESC;

I created it with access' query editor. It groups people by lastname+firstname and then counts how many last names are found for each such combination, then filters by rows returning more than 1 existing record.

Alex
Low-carb diet not working? Try the Low-food diet instead!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform