dimanche 10 mai 2015

SQLite query for getting column sum between date 1 and date 2 group by unique column 1,unique column 2

Table Structure

Table Name: Expense

eid- primary key

date- store expense date

amount- store expense amount

cat_id - store reference key for Category table

b_id -store reference key for budget table

===================================================

Now I want sum of amount between 2 dates group by unique or distinct cat_id,b_id

Aucun commentaire:

Enregistrer un commentaire