mysql报表服务_MYSQL之数据报表
SELECT f.month AS month, f.amount AS amountFROM (SELECT *FROM (SELECT month(t_dissipate) AS months, SUM(t_amount) AS amountFROM discuz.transactionWHERE year(t_dissipate) = '2018'GROUP BY month(t_dissi
SELECT f.month AS month, f.amount AS amount
FROM (
SELECT *
FROM (
SELECT month(t_dissipate) AS months, SUM(t_amount) AS amount
FROM discuz.transaction
WHERE year(t_dissipate) = '2018'
GROUP BY month(t_dissipate)
) t
RIGHT JOIN (
SELECT x.month AS month
FROM discuz.months x
UNION
SELECT month(t_dissipate) AS months
FROM discuz.transaction
GROUP BY month(t_dissipate), t_amount
) d
ON t.months = d.month
) f
months表: 月份 int类型 1-12
transaction:数据表 :新增时间 t_dissipate datetime 若干条
:数量 amount int 对应新增时间条数
永洪科技，致力于打造全球领先的数据技术厂商，具备从数据应用方案咨询、BI、AIGC智能分析、数字孪生、数据资产、数据治理、数据实施的端到端大数据价值服务能力。
更多推荐
0
0- 0
已为社区贡献1条内容
所有评论(0)