MySQL按年、月、日分组统计数据

MySQL按年、月、日分组统计数据

1.按年分组

SELECT DATE_FORMAT(CREATE_TIME,'%y') years,COUNT(*) count
FROM Order_Table 
GROUP BY years;

2.按月分组

SELECT DATE_FORMAT(CREATE_TIME,'%y-%m') months,COUNT(*) count
FROM Order_Table 
GROUP BY months;

3.按日分组

SELECT DATE_FORMAT(CREATE_TIME,'%y-%m-%d') days,COUNT(*) count
FROM Order_Table 
GROUP BY days;