Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filter for Unique??
Message
De
07/02/2000 13:53:04
 
 
À
07/02/2000 13:36:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00328390
Message ID:
00328400
Vues:
22
>I have a print file which is created by selecting addresses from multiple database files. Thereby, the same names may be selected
>
>Is there a simple way to command to filter the file for unique names?
>I know I can sort and then compare records but was wondering if there is an easier way.
>
>Thanks
>
>Todd

You can run a select statement that will return records with duplicate values:

SELECT COUNT(*), * FROM SomeTable GROUP BY KeyField1, KeyField2 HAVING COUNT(*) > 1

the fields in the GROUP BY are what determines uniqueness.
Erik Moore
Clientelligence
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform