Group by month

[corkg]

Is it possible to run a sql query that will group all months

the dates are ordered dd/mm/yyyy in the database

how can I group the months together?

 

Thanks

[Xurion]

SELECT * FROM table GROUP BY date

[fenway]

SELECT * FROM table GROUP BY date

First, you can't select * with a GROUP BY.

 

Second, I don't even understand the question.

[Xurion]

I'm confused - I just successfully did a SELECT * with a GROUP BY  :-\

[fenway]

I'm confused - I just successfully did a SELECT * with a GROUP BY  :-\

You can do it, but anything other than the group-by'ed column will be meaningless!