[thelist] SQL: Order By Count

[Tab Alleman]

Rob Smith wrote:
> Yah Tab, try this:
>
> SELECT COUNT(*) as QueryCount, Month(TimeStamp),
> DayOfMonth(TimeStamp), Destination FROM Logger WHERE (TimeStamp
> BETWEEN '20030213000000' AND '20030218000000') GROUP BY
> Month(TimeStamp), DayOfMonth(TimeStamp), Destination Order by
> QueryCount

Ok, I did and it works but The Thing is that the Order By QueryCount
overrides the Group ordering, so to really get what I wanted I actually
had to add:  ORDER BY Month(TimeStamp), DayOfMonth(TimeStamp),
QueryCount

..and now it's beautiful.  Thanks!
T