LeetCode · January 31, 2021

Duplicate Emails | LeetCode 182 | SQL | Solution

This one is a simple SQL problem. Here is the link to this problem.

This one is an absolute beginner type problem. We have to query all the duplicates emails from the given table. The name of the table is Person.

The code is almost self-explanatory.

SELECT Email FROM Person GROUP BY Email HAVING COUNT(Email) > 1

All SQL keywords are written in uppercase letters. It’s not mandatory but a convention.