Skip to content

Commit 6cb4fd5

Browse files
authored
duplicate-emails
1 parent 229031c commit 6cb4fd5

File tree

1 file changed

+6
-1
lines changed

1 file changed

+6
-1
lines changed

MySQL/duplicate-emails.sql

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,10 @@
11
# Time: O(n^2)
22
# Space: O(n)
33

4-
SELECT Email FROM Person GROUP BY Email HAVING COUNT(*) > 1
4+
/** # Write your MySQL query statement below **/
5+
6+
SELECT Email
7+
FROM Person
8+
GROUP BY Email
9+
HAVING COUNT(*) > 1
510

0 commit comments

Comments
 (0)