Get Duplicate Values MySQL

Get Duplicate Values MySQL

Simply group on all required columns.

SELECT
    customer_name, customer_email, customer_age, COUNT(*)
FROM
    users
GROUP BY
    customer_name, customer_email, customer_age
HAVING 
    COUNT(*) > 1