mysql按月查询

SELECT DATE_FORMAT(GenerateTime, '%m') as month, SUM(GenerateCount) AS count FROM identitycodetask
WHERE DATE_FORMAT(GenerateTime, '%Y')='' AND ProductId=''
GROUP BY DATE_FORMAT(GenerateTime, '%Y-%m')
上一篇:HDOJ-ACM1012(JAVA)


下一篇:div内容超出后自动显示滚动条