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