CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
Query for duplicate records
|
vime
Junior Member
Registered: Jul 2000
Location: UK
Country:
State:
Certifications:
Working on:
Total Posts: 10
|
|
 Query for duplicate records
I have 8000 rows of data. They are some duplicate rows but do not know the SQL statement to find out the duplicates(about 250).
Any ideas
Thanks
Report this post to a moderator
|
|
 11-15-01 02:01 PM
|
|
colinbun
Junior Member
Registered: Nov 2001
Location:
Country: United Kingdom
State:
Certifications: MCDBA
Working on:
Total Posts: 2
|
|
 Re: Query for duplicate records
There are a few ways to do this, the easiest depends on the number of fields in the table. One way, if you have 2 fields, is -
select fieldA,fieldB,count(*) from table group by fieldA,fieldB having count(*) > 1
Hope this helps,
Colin
Report this post to a moderator
|
|
|
11-22-01 02:17 PM
|
|
|
MCSE exam notes
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is ON. |
|
ExamNotes forum archive
|
