MySQL: Get Count of rows and add specific value to total count from each row

Question

I have this table:

I need to count every row where tblEventID is 32. So the result will be 3. (easy aggregate function):

SELECT COUNT(status) FROM ...

BUT:

I need to also add the value in column plusOnes to the overall.

So the result must be 3 (count) + 2 + 2 + 0 = 7.

Meaning I have to look at each row individually, add the value from plus one and in the end add the total count.

How is this achieved?

Kurt Kline · Accepted Answer · 2021-10-05 12:28:07Z

1

You can achieve this by adding the count of rows, and the sum of plusOnes together

SELECT COUNT(status) + SUM(plusOnes) FROM ...

answered Oct 5, 2021 at 12:28

Kurt Kline

2,1291 gold badge15 silver badges24 bronze badges

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

1 Comment

Hey, thats easy! Didnt think it was gonna be just these few lines. Awesome!