>What would be a good way to do a SQL query if I have a date field in my table and I want to gather informations based on the months. I mean there could be data in the month of november 2008 but also november 2007.
>
>How can I manage to get the sum for november 2007 and then november 2008 all in the same query?

group by year(datefiled), month(datefield)