How to Find Duplicate Records in a MySQL I Tech Arise

In this tutorial, We will show you How to Update CSS content property dynamically. The Best approach is to use GROUP BY and HAVING condition. It is more effective and faster.

Also Read: How to Converting timestamp to time ago in PHP

For example, MySQL query looks like this:

Example 1:

// MySQL query looks like
SELECT 
      name,
      employee.email 
   FROM employee
      INNER JOIN (SELECT email
                  FROM   employee
                  GROUP  BY email
                  HAVING COUNT(id) > 1) dup
              ON employee.email = dup.email

// MySQL query looks like

SELECT

name,

employee.email

FROM employee

INNER JOIN (SELECT email

FROM employee

GROUP BY email

HAVING COUNT(id) > 1) dup

ON employee.email = dup.email

Example 2:

// MySQL query looks like
SELECT
      name, email, COUNT(*)
   FROM employee
      GROUP BY name, email
      HAVING COUNT(*) > 1

// MySQL query looks like

SELECT

name, email, COUNT(*)

FROM employee

GROUP BY name, email

HAVING COUNT(*) > 1

Also Read: How to Update CSS Content Property Dynamically