/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 vote327 views2 answers
Restart identity cascade
SQL
0 vote299 views1 answer
Split a string with expression and get the last value of split sql
SQL
25 votes354 views3 answers
How to use a database to see tables mysql
SQL
0 vote355 views2 answers
Sql having multiple conditions
SQL
0 vote350 views1 answer
Oracle table privileges
SQL
1 vote346 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote344 views1 answer
Select into table variable
SQL
0 vote349 views1 answer
Postrgres trunc
SQL
0 vote348 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
2 votes334 views2 answers
Sql first character
SQL