Compare records in the same table

How can I compare records in the same table.  For example how could I compare a payment from the customer for the current month vs the prior month?  I need to be able to identify payments that have a ...