Question

oracle中查出某个字段重复的次数并计算重复次数的总和

Answer 1

用count既可以查出重复次数。
例：tabletest 表，有A、B、C3个字段。要查找字段B的重复次数
select count(A), B from tabletest group by B;
即可查出B字段下每个值的重复次数，如果要查有重复数据的总和
select count(A), B from tabletest group by B having count(A)>1;

Answer 2

select 字段,count(*) from table group by 字段;