Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql to find duplicates
Message
De
17/07/2003 12:13:31
 
 
À
17/07/2003 12:09:41
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00811118
Message ID:
00811134
Vues:
13
>Hi Sergey!
>
>Are there some difference in performance will have been written thus?
>
>select KeyFld from TestDups group by 1 ;
>     having count(KeyFld) > 1 ;
>     into cursor curDupes
>
>Bye!



Erick

I am not sure, even if it works properly, that it is ANSI compliant.
Besides, you are not creating the Count calculated column, therefore you will not know how many duplicates of each you have, which may be important.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform