Oracle中按分钟统计某字段的数量

select  * from xxx[表名]

表中有username，authdate两个字段，可看到authdate字段为yyyy/mm/dd hh24:mi:ss类型的时间，按分钟统计有多少条username数据加载进数据库

select to_char(t.authdate,'yyyy/mm/dd hh24:mi') authdate,count(1) sm  from b_broadband_authfail4 t  group by to_char(t.authdate,'yyyy/mm/dd hh24:mi') order by to_char(t.authdate,'yyyy/mm/dd hh24:mi');

以上sql语句可按分钟查出此表每分钟有多少条数据