AS1 [Oracle]입양 시각 구하기(1) 시간 추출 EXTRACT(HOUR FROM CAST (DATETIME AS TIMESTAMP)) 그룹 묶고 개수 GROUP BY COUNT(*) SELECT EXTRACT(HOUR FROM CAST (DATETIME AS TIMESTAMP)) AS HOUR, COUNT(*) AS COUNT FROM ANIMAL_OUTS WHERE EXTRACT(HOUR FROM CAST (DATETIME AS TIMESTAMP)) BETWEEN 9 AND 20 GROUP BY EXTRACT(HOUR FROM CAST (DATETIME AS TIMESTAMP)) ORDER BY EXTRACT(HOUR FROM CAST (DATETIME AS TIMESTAMP)) 코딩테스트 연습 - 입양 시각 구하기(1) ANIMAL_OU.. 2021. 10. 5. 이전 1 다음
