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