-
Querying for duplicate fields
This sounds simple but having trouble constructing the query - I'm trying to write a query that will pull out all the duplicate fields from a
very huge database. There are around 200,000 records with a field called 'code' Code is a CHAR(9) field with no unique constraint.
I'm just trying to check the data to make sureall the data there is unique.
I ran 2 queries to check this:
1. Select count(code) from TABLE
RESULT (200,000 rows affected)
2. Select distinct count(code) from TABLE
RESULT (199,950 rows affected)
So apparenlyt 50 codes are repeats of each other. I don't want to scroll down 200,000 records to determine which are duplicates. I tried group by but that still generates a whole
list of (1's) which still requires me having to scroll down the page slowly to see if there is a number greater than 2.
Any know of an easier way I can get this info?
Joy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|