![[SQL문제풀기] 최댓값 구하기](https://image.inblog.dev?url=https%3A%2F%2Fsource.inblog.dev%2Ffeatured_image%2F2024-12-21T19%3A12%3A03.343Z-af096330-5026-428a-a916-ffb8c3a902d0&w=3840&q=75)
문제
내가 작성한 정답 1 - MYSQL
SELECT DATETIME
FROM ANIMAL_INS
ORDER BY DATETIME DESC
LIMIT 1;내가 작성한 정답 2
SELECT DATETIME
FROM ANIMAL_INS
WHERE DATETIME = (SELECT MAX(DATETIME) FROM ANIMAL_INS);내가 작성한 정답 1 -ORACLE
SELECT DATETIME
FROM (SELECT * FROM ANIMAL_INS ORDER BY DATETIME DESC)
WHERE ROWNUM = 1;내가 작성한 정답 2 - MYSQL과 동일
SELECT DATETIME
FROM ANIMAL_INS
WHERE DATETIME = (SELECT MAX(DATETIME) FROM ANIMAL_INS);Share article