Group by month in SQLite

المشرف العام

Administrator
طاقم الإدارة
I have a SQLite Database which contains values, each of them having a dateI want to retrieve the sum of the values grouped by month

Date (as numeric) Value (as real number)
2012/05/01 302012/06/01 35...

2015/12/12 45

How could I do this?

Thank you



أكثر...
 
أعلى