# \#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`
×
Sign in
Email
Password
Forgot password
or
By clicking below, you agree to our
terms of service
.
Sign in via Facebook
Sign in via Twitter
Sign in via GitHub
Sign in via Dropbox
Sign in with Wallet
Wallet (
)
Connect another wallet
New to HackMD?
Sign up