Programmers_MySQL
[Programmers] MySQL 동명 동물 수 찾기
콩유니
2024. 1. 31. 16:08
SELECT NAME, COUNT(NAME) as COUNT
FROM ANIMAL_INS
GROUP BY NAME
HAVING COUNT > 1
ORDER BY NAME