Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql to find duplicates
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00811118
Message ID:
00811223
Views:
14
>>
select KeyFld, count(*) as CntDups from TestDups group by 1 ;
>>     having CntDups > 1 ;
>>     into cursor curDupes
>>
>
>Thanks for the quick reply. I lost count on how many times you've helped me but it's always so appriciated.
>Allen

You're welcome.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform