But strangely enough I never got the original message that I posted.
thanks again
Deanna Schneider wrote:
> Try this:
> select sum(UNIQUE_VISITs) As sys_sum, to_char(unique_date,'MON') AS
> MONTH from unique_sessions
> WHERE SITE = '#client#'
> GROUP BY TO_CHAR(unique_date,'MON')
> ORDER BY TO_DATE(TO_CHAR(unique_date, 'MON'), 'MON')
>
>
> > select sum(UNIQUE_VISITs) As sys_sum, to_char(unique_date,'MON') AS
> > MONTH from unique_sessions
> > WHERE SITE = '#client#'
> > GROUP BY TO_CHAR(unique_date,'MON')
> > It returns the results sorted by alpha like this, but I would like to
> > get date order..
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
