[sql] ROOT 아이템 구하기

whitehousechef·2025년 12월 1일

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

initial

too simple we just join 2 tables and filter rows that have null values for parent item id

select a.item_id, a.item_name
from item_info a
join item_tree b
on a.item_id = b.item_id
where b.parent_item_id is null

0개의 댓글