![[SQL문제다시풀기] 상위 n개 레코드 - limit와 rownum](https://image.inblog.dev?url=https%3A%2F%2Fsource.inblog.dev%2Ffeatured_image%2F2025-02-09T16%3A31%3A07.821Z-b17ff1b8-1e01-4950-80bf-9ae531f894db&w=3840&q=75)
문제
MYSQL
내가 작성한 정답
select name
from animal_ins
order by datetime asc
limit 1select name
from animal_ins
where datetime = (select min(datetime) from animal_ins)ORACLE
내가 작성한 정답
select *
from (SELECT name from animal_ins order by datetime asc)
where rownum = 1mysql의 두번째 정답과 동일
select name
from animal_ins
where datetime = (select min(datetime) from animal_ins)Share article