Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding Duplicates on SQL server 6.5
Message
From
10/03/2000 21:06:05
Michael Levy
Cincinnati, Ohio, United States
 
 
To
10/03/2000 16:02:55
Christopher Pinnock
United General Insurance Company
Kingston, Jamaica
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Re: Finding Duplicates on SQL server 6.5
Miscellaneous
Thread ID:
00344400
Message ID:
00344517
Views:
18
>How can I get all duplicate records from SQL server 6.5. Need the answer urgently.

SELECT id, COUNT(*) FROM table GROUP BY id HAVING COUNT(*) > 1

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform