[프로그래머스] 없어진 기록찾기

AI·2025년 9월 29일

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

SELECT o.ANIMAL_ID, o.NAME from ANIMAL_OUTS o where not exists 
(select i.ANIMAL_ID from ANIMAL_INS i where i.ANIMAL_ID = o.ANIMAL_ID);
SELECT o.ANIMAL_ID, o.NAME 
from ANIMAL_OUTS o 
where not exists 
(select 1 from ANIMAL_INS i where i.ANIMAL_ID = o.ANIMAL_ID)
order by o.ANIMAL_ID;

0개의 댓글