只需使用MONTH（）和YEAR（）函数
SELECt COUNT(*) as `count`, `region`, YEAR(`date`) as `year`, MonTH(`date`) as `month` FROM my_stores.stats WHERe YEAR(`date`) in (2012,2013) GROUP BY `region`, YEAR(`date`),MonTH(`date`)
只需使用MONTH（）和YEAR（）函数
SELECt COUNT(*) as `count`, `region`, YEAR(`date`) as `year`, MonTH(`date`) as `month` FROM my_stores.stats WHERe YEAR(`date`) in (2012,2013) GROUP BY `region`, YEAR(`date`),MonTH(`date`)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
