select to_char(date1,'yyyy/mm'),count(*) from table1 group by to_char(date1,'yyyy/mm')
近一年的就select to_char(foccurdate,'yyyy/mm') d,count(*) c from wz_enterbill eb where eb.foccurdate>=add_months(sysdate,-11) group by to_char(foccurdate,'yyyy/mm')
select to_char(date,'yyyymm') as month,count(*) num from table group by to_char(date,'yyyymm')
group by to_char(date1,'yyyy/mm')
where eb.foccurdate>=add_months(sysdate,-11)
group by to_char(foccurdate,'yyyy/mm')
group by to_char(date,'yyyymm')