该博客介绍了一种在MySQL中查询当前年份1到12月的交易量和金额的方法，通过日期格式化和聚合函数，分别获取每个月的交易数量和总金额。
MySql查询当年1-12月数据。
SELECT COUNT(*) AS JanTradingVolume, COALESCE(SUM(tt.amount),0) AS JanAmount,
(SELECT COUNT(*) FROM tt_trade tt
WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-02')) AS FebTradingVolume,
(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt
WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-02')) AS FebAmount,
(SELECT COUNT(*) FROM tt_trade tt
WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-03')) AS MarTradingVolume,
(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt
WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-03')) AS MarAmount,
(SELECT COUNT(*) FROM tt_trade tt
WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-04')) AS AprTradingVolume,
(SEL
最低0.47元/天 解锁文章
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
