[SQL문제풀기] 최솟값 구하기

silver

May 29, 2025

Contents

문제 MYSQL ORACLE

문제

school.programmers.co.kr

https://school.programmers.co.kr/learn/courses/30/lessons/59038

MYSQL

내가 작성한 정답


#1
select min(datetime) from animal_ins;

#2
select datetime
from animal_ins
order by 1
limit 1;

ORACLE

내가 작성한 정답


--1
select min(datetime) from animal_ins;

--2 rows가 아니라 row도 가능
select datetime
from animal_ins
order by datetime 
fetch first 1 row only;

--3
select datetime
from (select datetime from animal_ins order by datetime)
where rownum =1;