[thelist] Monthly Counts in order

[Michele Foster (WizarDev)]

----- Original Message ----- 
From: "Michele Foster (WizarDev)" <michele at wizardev.ca>


> Another SQL question ...
>
> SELECT Month(RefDate) as MyMonth, Year(RefDate) as MyYear, COUNT
> (Month(RefDate)) AS MonthlyTotal
>   FROM ext_Refs
>   GROUP BY Month(RefDate), Year(RefDate)
>
> This is giving me the correct totals for the month ..
>
> October 2004 = 32
> January 2005 = 158
> May 2004 = 44
>

I got this figured out this morning ... I guess a few hours sleep does help
sometimes.  :)

In case anyone is wondering, my Order By after my Group By is ..
ORDER BY Year(RefDate) DESC, Month(RefDate) DESC

Mich