[SQL] 프로그래머스_59041_동명 동물 수 찾기

GROUP BY, HAVING 이용하기

SELECT [컬럼명] 
FROM [테이블명] 
GROUP BY [컬럼명] 
HAVING [조건절]

 

https://school.programmers.co.kr/learn/courses/30/lessons/59041

프로그래머스

 

 

SELECT NAME, COUNT(NAME)
FROM ANIMAL_INS
GROUP BY NAME
HAVING COUNT(NAME) > 1 
AND NAME IS NOT NULL
ORDER BY NAME;

 

GROUP BY