728x90
https://leetcode.com/problems/duplicate-emails/submissions/
Duplicate Emails - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
[problem]
email데이터 중복없이 정보 출력하기
[analysis]
1. 중복된 이메일 제외 위해서 email로 group by 해줌
2. having count email >1 (2이상이면 중복임)
* having은 group by에서 연산한 결과물에 조건을 줄 때 사용 where과는 다르다.
[solution]
728x90
'MS SQL > MS SQL : Leetcode' 카테고리의 다른 글
| SQL - 586. Customer Placing the Largest Number of Orders (select, count) (0) | 2022.04.26 |
|---|---|
| SQL - 511. Game Play Analysis I (min, group by) (0) | 2022.04.26 |
| SQL - 183. Customers Who Never Order (left join, where) (0) | 2022.04.26 |
| SQL - Leetcode 620. Not Boring Movies (where, order by) (0) | 2022.04.25 |
| SQL - Leetcode 175. Combine Two Tables (left join) (0) | 2022.04.25 |