---
# System prepended metadata

title: \#182 Duplicate Emails
tags: [leetcode, leetcode-easy, sql]

---

# \#182 Duplicate Emails
## *找出table內重複出現的eamil*
## Log
 - build 20210417 by syhuang

## 初見
 - group+having基本用法
```sql=
select Email from(
select count(Id), Email
  from Person
 group by Email
having count(Id) > 1) t
```
## 備註
 - 初見即畢業
## 參考
###### tags: `leetcode`, `leetcode-easy`, `sql`