inblog logo
|
silver
    SQL문제풀기

    [SQL문제풀기] ROOT 아이템 구하기

    silver's avatar
    silver
    Jul 04, 2025
    [SQL문제풀기] ROOT 아이템 구하기
    Contents
    문제MYSQL

    문제

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

    MYSQL

    내가 작성한 정답

    SELECT T.ITEM_ID, I.ITEM_NAME FROM ITEM_TREE T JOIN ITEM_INFO I ON T.ITEM_ID = I.ITEM_ID WHERE T.PARENT_ITEM_ID IS NULL ORDER BY 1;
    Share article

    silver

    RSS·Powered by Inblog