Posted 2013/10/21 10:23 Filed under 프로그래밍 SELECT ERROR_CODE, DATE_FORMAT( CREATE_DATE, '%m-%d' ), COUNT(1) FROM TBL_NAME WHERE ERROR_CODE='E000' GROUP BY ERROR_CODE, DATE_FORMAT( CREATE_DATE, '%m-%d' ) 2013/10/21 10:23 2013/10/21 10:23