Server所有财政年度(4月至3月)的财政年度报表
Server所有财政年度(4月至3月)的财政年度报表
提问于 2015-04-23 10:45:14
在哪里可以像这样使用T动态生成过去10年的财政年度报告：
Months |2007-2008 |2008-2009| 2009-2010 |2010-2011 | Average
-------------------------------------------------------------------
April
May
June
July
August
September
October
November
December
January
February
March
Average 回答 1
Stack Overflow用户
回答已采纳
发布于 2015-04-23 11:56:58
我不知道日期时间代表什么，我假设它是月或年的指示器，如果不是，您需要更改where语句以合并年份和月份。
试着做这样的事情：
SELECT '2007-2008' AS FISCALYEAR, SUM(EXPENSE) AS EXPENSE
FROM YOURTABLE
WHERE [DATETIME] BETWEEN '4/1/2007' AND '3/31/2008'
UNION ALL
SELECT '2008-2009' AS FISCALYEAR, SUM(EXPENSE) AS EXPENSE
FROM YOURTABLE
WHERE [DATETIME] BETWEEN '4/1/2008' AND '3/31/2009'
UNION ALL
SELECT '2009-2010' AS FISCALYEAR, SUM(EXPENSE) AS EXPENSE
FROM YOURTABLE
WHERE [DATETIME] BETWEEN '4/1/2009' AND '3/31/2010'
UNION ALL
SELECT '2010-2011' AS FISCALYEAR, SUM(EXPENSE) AS EXPENSE
FROM YOURTABLE
WHERE [DATETIME] BETWEEN '4/1/2010' AND '3/31/2011'这应该会让你接近每一个财政年度的支出。要得到平均值，只需做同样的工作并将其聚合起来。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/29821129
复制相关文章
相似问题
腾讯云开发者
