Blogs Hub

by Sumit Chourasia | Oct 16, 2020 | Category :coding | Tags : algorithm data-structure easy leetcode

Duplicate Emails - Sql - Easy - LeetCode

Duplicate Emails - Sql - Easy - LeetCode

Write a SQL query to find all duplicate emails in a table named Person.

+----+---------+
| Id | Email   |
+----+---------+
| 1  | a@b.com |
| 2  | c@d.com |
| 3  | a@b.com |
+----+---------+
For example, your query should return the following for the above table:

+---------+
| Email   |
+---------+
| a@b.com |
+---------+
Note: All emails are in lowercase.

# Write your MySQL query statement below
Select Email From Person Group By Email having count(*) > 1;

Contributed By: Sumit Chourasia
Defuse the Bomb - Array - Easy - LeetCode
Contributed By: Sumit Chourasia
Valid Triangle Number - Array - Medium - LeetCode
Contributed By: Sumit Chourasia
Reformat Phone Number - String - Easy - LeetCode