mysql当年数据_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,

(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-04')) AS AprAmount,

(SELECT COUNT(*) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-05')) AS MayTradingVolume,

(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-05')) AS MayAmount,

(SELECT COUNT(*) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-06')) AS JunTradingVolume,

(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-06')) AS JunAmount,

(SELECT COUNT(*) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-07')) AS JulTradingVolumeMySQL 查询数据,

(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-07')) AS JulAmount,

(SELECT COUNT(*) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-08')) AS AugTradingVolume,

(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-08')) AS AugAmount,

(SELECT COUNT(*) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-09')) AS SepTradingVolume,

(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-09')) AS SepAmount,

(SELECT COUNT(*) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-10')) AS OctTradingVolume,

(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-10')) AS OctAmount,

(SELECT COUNT(*) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-11')) AS NovTradingVolume,

(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-11')) AS NovAmount,

(SELECT COUNT(*) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-12')) AS DecTradingVolume,

(SELECT COALESCE(SUM(tt.amount),0) FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-12')) AS DecAmount

FROM tt_trade tt

WHERE DATE_FORMAT(tt.creationtime,'%Y-%m') = CONCAT(YEAR(NOW()),'-01')

（编辑：好传媒网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!