/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

4 votes233 views1 answer
Restart for pg_hba.conf file
SQL
2 votes247 views1 answer
Sql server case sensitive search
SQL
0 vote236 views1 answer
Sequelize postgresql schema
SQL
0 vote249 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote269 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote233 views1 answer
Mysql count by month
SQL
3 votes198 views1 answer
Postgresql where current year
SQL
1 vote232 views1 answer
Sql list all procedures
SQL
6 votes221 views4 answers
Sqlite drop table
SQL
0 vote260 views1 answer
Oracle session statistics
SQL