Programming/SQL
2021. 1. 31.
[MYSQL] SELECT groupby FROM Programmers
SELECT ANIMAL_TYPE, COUNT(ANIMAL_ID) AS count FROM ANIMAL_INS GROUP BY ANIMAL_TYPE; SELECT NAME, COUNT(ANIMAL_ID) AS COUNT FROM ANIMAL_INS WHERE NAME IS NOT NULL GROUP BY NAME HAVING COUNT>=2 ORDER BY NAME; HAVING - GROUP의 조건 SELECT HOUR(DATETIME) AS HOUR, COUNT(ANIMAL_ID) AS COUNT FROM ANIMAL_OUTS GROUP BY HOUR HAVING HOUR >=9 AND HOUR hour이라는 변수를 -1로 초기화