![[SQL문제풀기] 최솟값 구하기](https://image.inblog.dev?url=https%3A%2F%2Fsource.inblog.dev%2Ffeatured_image%2F2024-12-21T19%3A19%3A40.838Z-821f8c70-218c-481d-a94a-670d7a5fe833&w=3840&q=75)
문제
내가 작성한 정답1 - MYSQL
SELECT DATETIME
FROM ANIMAL_INS
ORDER BY DATETIME ASC
LIMIT 1;내가 작성한 정답2
SELECT DATETIME
FROM ANIMAL_INS
WHERE DATETIME = (SELECT MIN(DATETIME) FROM ANIMAL_INS);내가 작성한 정답1 - ORACLE
SELECT *
FROM (SELECT DATETIME FROM ANIMAL_INS ORDER BY DATETIME ASC)
WHERE ROWNUM = 1;내가 작성한 정답2
SELECT DATETIME
FROM ANIMAL_INS
WHERE DATETIME = (SELECT MIN(DATETIME) FROM ANIMAL_INS);Share article