/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 vote124 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote126 views1 answer
Selecting Multiple Columns in SQL
SQL
1 vote114 views1 answer
Mysql list bigger table
SQL
9 votes103 views4 answers
How to remove duplicate in sql
SQL
0 vote107 views1 answer
Search from comma separated values in sql server
SQL
0 vote108 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote114 views1 answer
Import excel to sql
SQL
0 vote169 views1 answer
TSQL Find csv file in folder
SQL
7 votes106 views1 answer
Mysql remote connection command line
SQL
4 votes135 views5 answers
Get last query in codeigniter 4
SQL