동명 동물 수 찾기

빛하루 2023. 9. 2. 16:51

SELECT NAME,count(*) as COUNT
FROM ANIMAL_INS 
GROUP BY NAME
HAVING count(NAME) >=2
ORDER BY NAME;