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