I have a table which looks like:
Name
A
A
A
A
B
B
B
B
C
C
D
E
F
F
F
G
select Name as Name,count(Name) as Repeat_Count
from call_data
GROUP BY 1
HAVING (Repeat_Count > 1);
Name Repeat_Count
A 4
B 4
C 2
D 1
E 1
F 3
G 1
select name,sum(repeat_count) from
(select Name as Name,count(Name) as Repeat_Count
from call_data
GROUP BY 1
HAVING (Repeat_Count > 1))temp;
Will return 16 for all records in name column is this what you want ?