get records from sqlite group by month

Posted by peacmaker on Stack Overflow See other posts from Stack Overflow or by peacmaker
Published on 2010-05-24T09:10:23Z Indexed on 2010/05/24 9:21 UTC
Read the original article Hit count: 223

Filed under:
|
|

hi 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

© Stack Overflow or respective owner

Related posts about c#

Related posts about sql