MAX()와 LIMIT 1
·
📁 SQL/📝
MAX([DISTINCT] expr)expr의 최대값을 리턴SELECT MAX(DATETIME) AS '시간'FROM ANIMAL_INSORDER BY DATETIME DESC LIMIT 1SELECT DATETIME AS '시간'FROM ANIMAL_INSORDER BY DATETIME DESCLIMIT 1 LIMIT 1 보다 MAX() 함수를 활용하자