SELECT DATE_FORMAT(GenerateTime,
'%m')
as month,
SUM(GenerateCount)
AS count FROM identitycodetask
WHERE DATE_FORMAT(GenerateTime,
'%Y')
='2019' AND ProductId
='1'
GROUP BY DATE_FORMAT(GenerateTime,
'%Y-%m')
转载于:https://www.cnblogs.com/siyunianhua/p/10627934.html
相关资源：JAVA上百实例源码以及开源项目
