[프로그래머스 SQL 고득점 kit(oracle)] String, Date - 오랜기간 보호한 동물(2)(level3)

https://programmers.co.kr/learn/courses/30/lessons/59411

프로그래머스

---

SELECT *
FROM (
    SELECT O.ANIMAL_ID, O.NAME
    FROM ANIMAL_INS I
    JOIN ANIMAL_OUTS O
    ON I.ANIMAL_ID = O.ANIMAL_ID
    ORDER BY (I.DATETIME - O.DATETIME) ASC
    )
WHERE ROWNUM < 3;