날짜별로 행의 집계값 얻기

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;