想查询一个表的结果集，又想统计其中某列符某行重复的次数
想查询一个表的结果集，又想统计其中某列符某行重复的次数
?
?
????????????? select cdr.vc2called_number,count(1) over (partition by substr(cdr.vc2called_number,1,length(cdr.vc2called_number)-1))? count_num from? ct_cdr cdr
??????????????????????? where? cdr.datbegincall >= sysdate-10/1440
