Oracle函数to_char应用示例

t.sj为时间字段，
根据时间字段的年月，和sffs字段分组，排序。并求出每组的总记录数 count
select to_char(t.sj, ‘yyyy-mm’) sj,
t.sffs sffs,
count(to_char(t.sj, ‘yyyy-mm’)) count –每组总记录数
from t_shzz_fzcsfdj t
where
–基本的过滤条件
to_char(t.sj, ‘yyyy’) = ‘2016’
and t.sfsqlb = ‘1’
and t.sflx = ‘1’
and t.is_effective = ‘1’
–根据时间字段的年月和 sffs分组
group by to_char(t.sj, ‘yyyy-mm’), t.sffs
–排序
order by sffs, sj