Joshua Olson wrote: >> SELECT Month(DateColumn), Year(DateColumn) >> FROM TableName >> GROUP BY Year(DateColumn), Month(DateColumn) > >> (the order of the GROUP BY clause is important) > Why is the ordering in the GROUP BY clause important in this query? Oops, it isn't.. I was confusing it with an ORDER BY clause.