-
identifying duplicate records...
I want to identify every record where a particular field matches the value in the same field in another record (in the same table).
Example:
Say I have the following table:
id | registrationName | registrationEmail
------------------------------------------------------------
123 | Michael | myoung@lehmans.com
456 | Michael2 | someOtherEmail@bogus.com
789 | Michael3 | myoung@lehmans.com
I want a query to identify the 1st and 3rd record, because those records have identical email addresses. Ideally, it would be really cool if I could select only the 3rd record because it has the higher id number.
In reality, I am dealing with a database that has over 200,000 records, so I obviously don't know each email address before hand.
Thanks in advance to anybody who can help me with this!
Sincerely,
Michael
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
|
|