orcal查询前N个月的数据

select d.monthDate,
       (select count(1)
          from tc_user t
         where to_char(t.create_time, 'yyyy-mm') = d.monthDate) as createnum
  from (select to_char(t, 'yyyy-mm') monthDate
          from (select decode(level,
                              1,
                              trunc(sysdate, 'dd'),
                              add_months(trunc(sysdate, 'mm'), 2 - 1 * level) - 1) t
                  from dual
                   --我这个是查询的半年的，如果查询其他的月份请 level < n+1
                connect by level < 7)) d order by d.monthDate;