inblog logo
|
silver
    SQL문제풀기

    [SQL문제풀기] 동명 동물 수 찾기

    silver's avatar
    silver
    Jan 08, 2025
    [SQL문제풀기] 동명 동물 수 찾기
    Contents
    문제MYSQL, ORACLE

    문제

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

    MYSQL, ORACLE

    SELECT NAME, COUNT(NAME) COUNT
FROM ANIMAL_INS
GROUP BY NAME
HAVING COUNT(NAME) >= 2
ORDER BY NAME ASC
    Share article

    silver

    RSS·Powered by Inblog