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]

Reply via email to