SW 프로그래밍/Mariadb

날짜별로 행의 집계값 얻기

N2info 2020. 9. 26. 01:54
SELECT DATE_FORMAT(column, ‘%Y%m%d’) as date, count(*)
FROM table
GROUP BY DATE_FORMAT(column, ‘%Y%m%d’)
ORDER BY date ASC;

 

SELECT DATE_FORMAT(rdate, '%Y%m%d') as date, count(*)
FROM `cc_3f_test`
GROUP BY DATE_FORMAT(rdate, '%Y%m%d')
ORDER BY date ASC;