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

문제

내가 작성한 정답1 - MYSQL

SELECT DATETIME
FROM ANIMAL_INS
ORDER BY DATETIME ASC
LIMIT 1;

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;

SELECT DATETIME
FROM ANIMAL_INS
WHERE DATETIME = (SELECT MIN(DATETIME) FROM ANIMAL_INS);