[Programmers] SQL 고득점 Kit - SUM,MAX,MIN

최댓값 구하기

MySQL

SELECT DATETIME 
  FROM ANIMAL_INS
 ORDER BY DATETIME DESC
 LIMIT 1

Oracle

SELECT DATETIME FROM
(
	SELECT DATETIME FROM ANIMAL_INS
	 ORDER BY DATETIME DESC
)
 WHERE ROWNUM <= 1

최솟값 구하기

MySQL / Oracle

SELECT MIN(DATETIME) 
  FROM ANIMAL_INS

동물 수 구하기

MySQL / Oracle

SELECT COUNT(*) 
  FROM ANIMAL_INS

중복 제거하기

MySQL / Oracle

SELECT COUNT(DISTINCT NAME) 
  FROM ANIMAL_INS