Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding duplicated records
Message
 
To
17/10/1996 22:04:06
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00010389
Message ID:
00010440
Views:
35
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform