Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining Duplicate Records
Message
 
 
To
01/03/2002 12:46:19
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00626759
Message ID:
00627094
Views:
14
This message has been marked as the solution to the initial question of the thread.
Then try:

select field1 + field2 + ... + field9 as PKey, count(*) as kount ;
from mytable ;
group by field1 + field2 + ... + field9 ;
having count(*) > 1
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform