select to_char(fasj,'yyyy-mm'),count(1) from table1 where fasj>=to_date('2009-4-22 14:01:48','yyyy-mm-dd hh24:mi:ss') and fasj<to_date('2010-4-22 14:01:48','yyyy-mm-dd hh24:mi:ss') group by to_char(fasj,'yyyy-mm')
select count(*) from t where fasj between date1 and date2 group by to_char(fasj,'yyyymm')
select to_char(fasj,'yyyy-mm'),count(*) sj from tab where fasj>=to_date('2009-4-22 14:01:48','yyyy-mm-dd hh24:mi:ss') and fasj<to_date('2010-4-22 14:01:48','yyyy-mm-dd hh24:mi:ss') group by to_char(fasj,'yyyy-mm')
select to_char(fasj,'yyyymm') fasj,count(*) from tb group by to_char(fasj,'yyyymm')
from table1
where fasj>=to_date('2009-4-22 14:01:48','yyyy-mm-dd hh24:mi:ss')
and fasj<to_date('2010-4-22 14:01:48','yyyy-mm-dd hh24:mi:ss')
group by to_char(fasj,'yyyy-mm')
from t
where fasj between date1 and date2
group by to_char(fasj,'yyyymm')
from tab
where fasj>=to_date('2009-4-22 14:01:48','yyyy-mm-dd hh24:mi:ss')
and fasj<to_date('2010-4-22 14:01:48','yyyy-mm-dd hh24:mi:ss')
group by to_char(fasj,'yyyy-mm')
select to_char(fasj,'yyyymm') fasj,count(*)
from tb
group by to_char(fasj,'yyyymm')