Oracle > Union and group by
Tuesday, March 1st, 2005 select
eff_date,
sum(number_of_items)
from
(select
to_char(effective_report_date,'mmyyyy') as eff_date,
count(*) number_of_items
from dm1
where to_char(effective_report_date,'mmyyyy') = '082004'
group by to_char(e
[...more...]