[SQL문제다시풀기] 상위 n개 레코드 - limit와 rownum

Feb 09, 2025

Contents


select name
from animal_ins
order by datetime asc
limit 1


select name
from animal_ins
where datetime = (select min(datetime) from animal_ins)


select * 
from (SELECT name from animal_ins order by datetime asc) 
where rownum = 1

mysql의 두번째 정답과 동일


select name
from animal_ins
where datetime = (select min(datetime) from animal_ins)

More articles