# \#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`