mysql 选择重复记录,在mysql中选择并显示重复记录

This question is pretty simple I for some reason cant get the proper result to display only the duplicate records

Table : Paypal_ipn_orders

id payer_email

1 susan@gmail.com

2 ryan@gmail.com

3 susan@gmail.com

4 steve@gmail.com

5 steve@gmail.com

SELECT id, COUNT( payer_email ) `tot`

FROM paypal_ipn_orders

GROUP BY payer_email

HAVING `tot` >1

sample output

id tot

1 2

4 2

expected output

id payer_email

1 susan@gmail.com

3 susan@gmail.com

4 steve@gmail.com

5 steve@gmail.com

How do I make this happen?

解决方案SELECT id, payer_email

FROM paypal_ipn_orders

WHERE payer_email IN (

SELECT payer_email

FROM paypal_ipn_orders

GROUP BY payer_email

HAVING COUNT(id) > 1

)