2020/12/30

[MYSQL] SELECT sum,max,min FROM Programmers

SELECT MAX(DATETIME) FROM ANIMAL_INS; SELECT MIN(DATETIME) FROM ANIMAL_INS; SELECT COUNT(*) AS 'COUNT' FROM ANIMAL_INS; COUNT -갯 수 return하는 쿼리 AS -보여줄 칼럼이름 지정 SELECT COUNT(DISTINCT NAME) AS 'COUNT' FROM ANIMAL_INS WHERE NAME IS NOT NULL; DISTINCT - 중복을 제거하는 쿼리