SELECT Email from Person
Group By Email
Having Count(*) > 1;
SELECT distinct p1.Email from Person p1
INNER JOIN Person p2
ON p1.Email = p2.Email
WHERE p1.Id <> p2.Id;
When I use the '!=' in to replace the '<>', I get a runtime error! Why??
in sql, only <> means unequal, no "!="
p1 join p2 on ...and...
I use '!=' but passed anyway
@wxs2204 I use the '!=',it has passed
@ohini why is the join done on email and not on id?
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.