문제
풀이
SELECT * from places
where host_id in(select host_id
from places
group by host_id
having count(host_id) > 1)
order by id
'algorithm' 카테고리의 다른 글
[programmers] MySQL - Lv.4 보호소에서 중성화한 동물 (join) (0) | 2022.09.29 |
---|---|
[HackerRank] MySQL - Employee Names (0) | 2022.09.28 |
[HackerRank] MySQL - Higher Than 75 Marks (0) | 2022.09.27 |
[programmers] MySQL - Lv.3 없어진 기록 찾기 (join) (0) | 2022.09.27 |
[HackerRank] MySQL - Weather Observation Station 12 (0) | 2022.09.26 |