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

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?

Contents hide

Answers:

Method 1

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

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

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

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating