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..
APR 580
AUG 765
FEB 69
JUL 664
JUN 441
MAR 354
MAY 552
SEP 774
I tried this
select unique_date, 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'), unique_date
and it returned all the possible records.
Is there a simple solution some thing I am missing?
System is Nt 4 running CF 5 and oracle 8.05
Thank you for your time.
michael
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
