Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Finding duplicated records
Message
 
À
17/10/1996 22:04:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00010389
Message ID:
00010440
Vues:
38
>>Ok,Ok, I have a silly question, but I need help :(
>>I need to find duplicated records in a numeric field,
>>Any sugestion?, can it be done with just one SQL
>>statement?
>
>SELECT yournumfield,COUNT(*) as occucence FROM youralias GROUP BY 1 INTO CURSOR TEMP
>BROWSE FOR occurence>1
Thanks a lot Michael, I tried and it worked...!!
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform