SQL how to add up the totals of the same data value

Question

I Have this table

|      status      |    month       |      years       |
|                  |                |                  |
|      resign      |     jan        |        2019      |
|      resign      |     jan        |        2019      |
|       Stay       |     feb        |        2019      |
|      resign      |     feb        |        2019      |

I want to sum total status with the same value and by month&years

The result should be this

|      resign      |    month       |        years     |
|         2        |     jan        |        2019      |
|         1        |     feb        |        2019      |

If you add (Stay, mar, 2019) to your sample data, do you want 0 for March, or should the March row not be in the result? — jarlh, Aug 15 '19 at 10:25

dewey · Accepted Answer · 2019-08-15T13:13:59.590

-1

This should work for you

select count(`status`) as `resign`, `month`, `years`
from t1 
where `status` = 'resign'
group by `month`, `status`, `years` ;

https://www.db-fiddle.com/f/gTTjUEPyynJciKx2DbypKY/8

edited Aug 15 '19 at 13:13

answered Aug 15 '19 at 10:26

dewey

809
2
16
47

SQL how to add up the totals of the same data value

1 Answers1