space11 · February 23, 2023 08:46
diff --git a/find-users-duplicate-email.sql b/find-users-duplicate-email.sql
 -- Find users ID that have the same email address
 SELECT u.id FROM `user` AS u
 INNER JOIN
 (
 	SELECT email FROM `user`
 	GROUP BY `user`.email HAVING count(id) > 1 
 ) AS u2 ON u2.email = u.email;
	-- Find users ID that have the same email address
	SELECT u.id FROM `user` AS u
	INNER JOIN
	(
	SELECT email FROM `user`
	GROUP BY `user`.email HAVING count(id) > 1
	) AS u2 ON u2.email = u.email;