MAX()와 LIMIT 1

MAX([DISTINCT] expr)

expr의 최대값을 리턴

SELECT MAX(DATETIME) AS '시간'
FROM ANIMAL_INS
ORDER BY DATETIME DESC

 

 

 

LIMIT 1

SELECT DATETIME AS '시간'
FROM ANIMAL_INS
ORDER BY DATETIME DESC
LIMIT 1

 

 

LIMIT 1 보다 MAX() 함수를 활용하자