[SQL문제풀기] 오랜 기간 보호한 동물(2)

문제

MYSQL

내가 작성한 정답

SELECT o.animal_id, o.name
from animal_ins i
join animal_outs o on i.animal_id = o.animal_id
order by DATEDIFF(o.datetime,i.datetime) desc
limit 2

ORACLE

내가 작성한 정답

select animal_id, name
from (SELECT o.datetime-i.datetime time, o.animal_id, o.name
        from animal_ins i
        join animal_outs o on i.animal_id = o.animal_id    
        order by time desc)
where rownum <= 2