/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 vote188 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote197 views1 answer
Mysql batch insert
SQL
4 votes177 views2 answers
How to delete row in sql
SQL
0 vote198 views3 answers
Sql drop all tables
SQL
0 vote196 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote207 views1 answer
Firebase sql
SQL
3 votes185 views2 answers
Having in mysql
SQL
2 votes190 views1 answer
Postgresql add entry to table
SQL
0 vote231 views1 answer
How to change mysql root password in windows 10
SQL
20 votes206 views5 answers
Sql show tables
SQL