Count columns according to dates in SQL

Question

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       |

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      |

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?

Thanks in advance, Steve-O

Alex Pliutau · Accepted Answer · 2012-01-27 12:41:43Z

2

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

answered Jan 27, 2012 at 12:41

Alex Pliutau

22k28 gold badges115 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joachim Isaksson · Accepted Answer · 2012-01-27 12:43:16Z

1

Try this instead

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

"GROUP BY date" puts all the individual dates on a separate line and does the sum separately per date.

answered Jan 27, 2012 at 12:43

Joachim Isaksson

182k28 gold badges298 silver badges308 bronze badges

Comments

animuson · Accepted Answer · 2012-02-24 04:34:28Z

1

select date, sum(counter)
from all_stats
group by date

edited Feb 24, 2012 at 4:34

animuson♦

54.9k28 gold badges142 silver badges150 bronze badges

answered Jan 27, 2012 at 12:48

Daniel

4392 gold badges9 silver badges20 bronze badges

Collectives™ on Stack Overflow

Count columns according to dates in SQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related