Oracle SQL-按周汇总和分组数据 [英] Oracle SQL - Sum and group data by week

问题描述

我有与日期有关的记录:

I have records related to dates:

DATE         AMOUNT
16.03.2013   3
16.03.2013   4
16.03.2013   1
16.03.2013   3
17.03.2013   4
17.03.2014   3

我知道如何每天对它们进行汇总，但是如何按周对其进行汇总?`

I know how to sum them up for each day, but how could I sum them up by week?`

推荐答案

尝试一下

SELECT to_char(DATE - 7/24,'IYYY'), to_char(DATE - 7/24,'IW'),SUM(AMOUNT)
FROM YourTable
GROUP BY to_char(DATE - 7/24,'IYYY'), to_char(DATE - 7/24,'IW')

游戏演示

FIDDLE DEMO

输出为:

+-----+-------+--------+
|YEAR | WEEK  | AMOUNT |
+-----+-------+--------+
|2013 | 11    | 18     |
|2013 | 13    | 3      |
+-----+-------+--------+

这篇关于Oracle SQL-按周汇总和分组数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！