且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

只选择并显示 MySQL 中的重复记录

更新时间:2023-01-29 20:31:02

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
)

sqlfiddle