Get Duplicate Values MySQL by 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 Please follow and like us: