[SQL] 프로그래머스 [Level-3] 오랜기간보호한동물(2)

<MySQL>

SELECT A.ANIMAL_ID
     , A.NAME
  FROM ANIMAL_OUTS A
 INNER JOIN ANIMAL_INS B
    ON A.ANIMAL_ID = B.ANIMAL_ID
 ORDER BY DATEDIFF(A.DATETIME, B.DATETIME) DESC
 LIMIT 2

<Oracle>

SELECT T.ANIMAL_ID
     , T.NAME
  FROM (
         SELECT A.ANIMAL_ID
              , A.NAME
           FROM ANIMAL_OUTS A
     INNER JOIN ANIMAL_INS B
             ON A.ANIMAL_ID = B.ANIMAL_ID
       ORDER BY TO_DATE(A.DATETIME) - TO_DATE(B.DATETIME) DESC
       ) T
WHERE ROWNUM <= 2

프로그래머스 오랜기간보호한동물 SQL