根据SQL中的日期计数列 [英] Count columns according to dates in SQL

问题描述

我需要帮助一个SQL语句。目标是计算每个日期的警报量。我的表看起来像这样：

I need help with a SQL statement. The goal is to count the amount of alarms of each date. My table looks something like this:

|----DATE----|---COUNTER---|---ALARM_ID---|
|2012-01-01  |     30      |      1       |
|2012-01-01  |     20      |      2       |
|2012-01-01  |     10      |      3       |
|2012-01-02  |     5       |      1       |
|2012-01-02  |     25      |      2       |
|2012-01-02  |     12      |      3       |
|2012-01-03  |     33      |      1       |
|2012-01-03  |     43      |      2       |
|2012-01-03  |     11      |      3       |

我正在寻找一个SQL语句，给出这个结果：

And I'm looking for a SQL statement that gives this result:

|----DATE----|---COUNTER---|
|2012-01-01  |     60      |
|2012-01-02  |     42      |
|2012-01-03  |     87      |

我一直在这个 SELECT日期SUM（计数器）FROM all_stats ，但我得到的是：

I've been working on this SELECT date, SUM(counter) FROM all_stats but all I get is:

|----DATE----|---COUNTER---|
|2012-01-01  |     60      |

我必须创建一个循环来检查所有日期并计数？

Do I have to create a loop to go through all dates and count?

提前感谢Steve-O

Thanks in advance, Steve-O

推荐答案

SELECT date, SUM(counter)
FROM all_stats
GROUP BY date

这篇关于根据SQL中的日期计数列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！