강의로 돌아가기
-

왜 틀렸나요..?

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

작성중인 코드―sql
1
2
-- 코드를 입력하세요
SELECT NAME, COUNT(NAME) FROM ANIMAL_INS WHERE NAME IS NOT NULL GROUP BY NAME HAVING COUNT(*) > 1
1 개의 답변
CodyBuilder-dev

결과는 이름 순으로 조회해주세요. <- ORDER BY를 넣어주시면 됩니다~

  • -

    감사합니다~

    -―Apr 20, 2021 18:19
답변 쓰기
This input form supports markdown syntax. Please refer to 마크다운 가이드.