[Leetcode] [SQL] Duplicate Emails

https://leetcode.com/problems/duplicate-emails/

Duplicate Emails

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

+----+---------+| Id | Email   |+----+---------+| 1  | [Email protected] | | 2  | [Email protected] | | 3  | [Email protected] |+----+---------+

For example, your query should return the following for the above table:

+---------+| Email   |+---------+| [Email protected] |+---------+

Select  from Group  by  having Count (*>1

[Leetcode] [SQL] Duplicate Emails