Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql to find duplicates
Message
From
17/07/2003 12:13:31
 
 
To
17/07/2003 12:09:41
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00811118
Message ID:
00811134
Views:
12
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform