/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 vote182 views1 answer
Foreign key multiple columns
SQL
0 vote178 views1 answer
Mysql dump everythign
SQL
0 vote182 views1 answer
Postgres read table structure
SQL
1 vote187 views1 answer
Top 10 rows in mysql
SQL
0 vote163 views1 answer
Mysql drop trigger
SQL
0 vote182 views1 answer
Firebase sql
SQL
3 votes176 views1 answer
Oracle revoke grant
SQL
3 votes185 views2 answers
Find string in stored procedure sql server
SQL
0 vote175 views1 answer
Android sqlite add column if not exists
SQL
0 vote189 views1 answer
Insert data from stored procedure into table
SQL