Duplicate Records SQL Question

Forgive me for asking what may be a simple question, but I am new to SQL and can't seem to figure this out..

I am trying to pull duplicate records out of a database that has the following fields:

Month, Memcode, Memid, PayAmt

How do I list only the duplicate records for every month that have a common memcode and payamt?

For example:

If jdoe (memid) has 2 payments for $10.00 (payamt) in October, 1 in november, and 3 in december, the script should show the following:

jdoe, october,$10.00, 2 occurances
jdoe, december,$10.00, 3 occurances

There are approximately 100,000 memid records in the table..

Any ideas?

Your humble Servant,
nyspy_at_my-deja.com Received on Mon Aug 20 2001 - 03:18:15 CDT