get records from sqlite group by month
i hve an sqlite db which contain transactions each transaction has an price
and has an transDate

i want to retrieve the sum of the transaction group by month

so the retrieved records should be like the following

Price    month
230        2
500        3
400        4

pleas any help
get records from sqlite group by month
===

i hve an sqlite db which contain transactions each transaction has an price
and has an transDate

i want to retrieve the sum of the transaction group by month

so the retrieved records should be like the following

Price    month
230        2
500        3
400        4

pleas any help