General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>I'm switching an index to a primary and am getting a duplicate index message. How can I find the duplicates amoung 1000's without
>>looking through them all?
>
>Select IDField, count(IDField) as nCount
> from MyTable
> group by IDField
> having nCount>1
Thanks very much!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only