/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

1 vote216 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote264 views2 answers
Mysql insert rows to another database
SQL
0 vote152 views1 answer
SQL joins in python
SQL
3 votes139 views3 answers
Docker create postgresql database
SQL
4 votes278 views2 answers
Sql display today's date
SQL
0 vote132 views1 answer
Postgres - Login and connect as default user
SQL
0 vote137 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
1 vote162 views1 answer
How to get alternate records from a table in sql
SQL
0 vote181 views1 answer
Cahnge column name apex oracle
SQL
-1 vote134 views1 answer
Partial search in sql
SQL