select to_char(wbsj,'mm') m, count(distinct id) ,substr(wbsj,0,4) y from 表 where 条件 group by substr(wbsj,0,4), to_char(wbsj,'mm');按月统计,按季度的话把mm换成q,quarter的简写。