查询今年每月注册的人数

表A

ID                     NAME                 REGDATE                  
---------------------- -------------------- -------------------------
1                      a                    26-1月 -10               
2                      b                    02-2月 -11               
3                      c                    26-2月 -11               
4                      d                    01-5月 -11               
5                      e                    02-5月 -11               
6                      f                    26-5月 -11               
7                      g                    26-4月 -11               

 

 

要求查询出今年每月注册的人数

月份                 人数                    
------- ----------------------
2011-02         2                     
2011-04         1                     
2011-05         3                     

 

Select a as "月份",Count(b) as "人数" From ( Select to_char(regdate,'YYYY-MM') a,to_char(regdate,'YYYY-MM') As b From A where to_char(regdate,'YYYY')=to_char(sysdate,'YYYY')) Group By b order by a