/SQL/Find duplicate users by email address in mysql

Find duplicate users by email address in mysql

SELECT users.name, users.uid, users.mail, from_unixtime(created)
FROM users
INNER JOIN (
  SELECT mail
  FROM users
  GROUP BY mail
  HAVING count(mail) > 1
) dupes ON users.mail = dupes.mail
ORDER BY users.mail;

Source: lutios.com

Similar codes

0 vote177 views3 answers
Query string not ending with with vowels
SQL
0 vote154 views1 answer
Mariadb set vertical output format
SQL
12 votes176 views1 answer
Docker run mysql image
SQL
14 votes191 views2 answers
Oracle add attribute to table
SQL
5 votes246 views4 answers
Sql check
SQL
0 vote165 views1 answer
Update set with inner join oracle
SQL
0 vote166 views1 answer
Kill a pid redshift
SQL
12 votes163 views4 answers
SQL Where
SQL
16 votes173 views3 answers
Tsql rename column name
SQL
0 vote177 views1 answer
Get rows from 1 table with other table empty mysql
SQL