想查询一个表的结果集，又想统计其中某列符某行重复的次数

?

?

????????????? 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